Yes I pasted the query m code you provided, and attached is what I got as a result. (Empty Table), the next step of that query is to filter to the fol...
Hello Philip, Thanks for your response. Using the M code you provided resulted in an empty table. When I changed the ApiVersion to 14, I did get ...
Thank you. I tried to use the parameter for dynamic file path pointing to my synced file, but got an error message there as well. Sadly, this won't ...
Thank you - I did realize that I wouldn't need a dynamic path if I could connect via Sharepoint, but I can't seem to get to the sharepoint folder I ne...
The supporting/dependent queries are automatically created by the "from folder" query. The only query that I create is the EnrollHistory query, and t...
🙂 - easy peasy. Pardon my lack of adventure. Thank you.
I am struggling with this formatting as well. When showing values as percentage of row totals, I can't seem to change the % value to no decimals. Th...
Thanks for both the formula and the measure. Now I need to try and learn more about the filter and all functions. But I certainly can use this. Tha...
Yes, the outcome is what I would expect. I see you added a custom column, but can you explain what that is doing?
Sorry for the slow reply. I've attached the data set. what I have is multiple entries for each student ID, and I just want to report the most recent...