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
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