Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Try using the "Group By" option in "Power Query Editor", it should resolve your issue..
Proud to be a PBI Community Champion
Try using the "Group By" option in "Power Query Editor", it should resolve your issue..
Proud to be a PBI Community Champion
This is it!
Thanks a lot!
Cosmin
some of the sources can have only one day and that's fine, i don't want to be deleted:)
thanks
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |