Forum Discussion
Solved
Removing duplicates based on a sort order
Hey folks I am trying to get rid of duplicate data and want to keep the record that was last modified. I added a sort but the remove duplicate transformation seems to ingore it.
I found the solution here in case anyone else needs it.
https://community.powerbi.com/t5/Desktop/Remove-duplicates-based-on-sort-in-Power-Query/m-p/592660#M281250
Ashish_Mathur
Super User
Super UserHi,
Share complete information. What do you want to group by? - revenue stream or some other column?