max date for each source from a folder

[cosminc]

Hi all,

i'm a little bit stucked with this:

i have a folder with many excel sources and each has row with dates and i need to obtain a table on query editor only with 2 columns and one row for each source like this: source name and max date form each; so somehow to delete from each source other dates wich are not the biggest

thanks in advance!

Cosmin

[PattemManohar · Accepted solution]

Try using the "Group By" option in "Power Query Editor", it should resolve your issue..

InputOutput

[cosminc]

This is it!

Thanks a lot!

Cosmin

[cosminc]

some of the sources can have only one day and that's fine, i don't want to be deleted:)

thanks