Solved: Remove duplicates - keeping the most recent row

Anonymous · ‎08-05-2019

Hi,

I need to remove duplicates rows but to do it selectively, by keeping the most recent value based on another column. In fact, my problem is exactly this one : https://community.powerbi.com/t5/Desktop/Selectively-remove-duplicate-rows/m-p/334489#M149648 but the solution does not works for me, I can sort rows the way I want it keeps filtering the same rows. Anyone has an idea how to select which duplicates i want to keep ?

ImkeF · ‎08-05-2019

Not sure if you've read through the whole post, but it is important to buffer the table before removing duplicates (Table.Buffer). Otherwise the sort order might not be kept.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

ImkeF · ‎08-05-2019

Not sure if you've read through the whole post, but it is important to buffer the table before removing duplicates (Table.Buffer). Otherwise the sort order might not be kept.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries