Showing results for 
Search instead for 
Did you mean: 
NumeritasMartin Frequent Visitor
Frequent Visitor

Power Query Max Date from large data set

Good Afternoon Powerbi team,


I was hoping someone could educate me on the best practice for my issue. I have a solution but I am positive it is the most memory inefficient solution.


Solution is being built in Excel 2013.


The model I am building gets data [an excel file per month] from three folders, so for a full year it is 36 files.


I need to identify the latest date/month these are for so I can apply my forecast to the following months.


For a dynamic solution I am simply referencing the dataset detailed above, remove all other non date columns and filter on the latest value and convert to a list. The problem is everytime it refreshes it checks every file and is time consuming.


Other option is of course to have a named range which the user updates, but I'd prefer a dynamic solution.


Anyone have any ideas?

Community Support Team
Community Support Team

Re: Power Query Max Date from large data set

Hi @NumeritasMartin,

From your description, I could not understand what is your desired result, could you please post more detail pictures about your data structure and your desired result if possible?



Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.