Forum Discussion

Aleph18's avatar
Aleph18
Frequent Visitor
7 years ago

Power Query - delete old date versions

Hi, I will like to keep the last data version of data for each date in the table using "edit queries", deleting oldest versions. In the below table I will like to keep the biggest version number for...
Need Help
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Aleph18 ,

 

you must create a subquery and group the data by date and maximum version. You can then merge the subquery with base data with an inner join

 

Check this.

PBIX

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.