Hi Fellow Power BI Users -
I have created a report by loading monthly excel-files from a folder into my model and display the trend in a bar chart. Additionally I would like to create a pie-chart only of the most recent excel-file.
What would be your recommended approach?
Currently I have two different queries, one for all files and the other with a filter for the most recent file.
However I can imagine a more efficient approach. If so, please let me know.
Thanks in advance and looking forward to hearing from you.