Forum Discussion
Solved
Drop duplicate rows retaining latest date
Hi All, I'd like to remove duplicates in my dataset based on a logical primary key (ID) and retain the latest modified records values.
You can achieve this using power query, click query editor and copy the original table. Then click "Transform"-> "Group By" as below:
Then merge the original table with duplicated tabel as below:
The result is as below, you can also refer to the pbix file.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
