cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cosminc Member
Member

max date for each source from a folder

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

 

example.jpg

 

 

thanks in advance!

Cosmin

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: max date for each source from a folder

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

 

image.pngInputimage.pngOutput



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





3 REPLIES 3
cosminc Member
Member

Re: max date for each source from a folder

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

thanks

Highlighted
Super User
Super User

Re: max date for each source from a folder

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

 

image.pngInputimage.pngOutput



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





cosminc Member
Member

Re: max date for each source from a folder

This is it!

Thanks a lot!

Cosmin

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 258 members 2,729 guests
Please welcome our newest community members: