Forum Discussion
Remove duplicates - keeping the most recent row
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 ?
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.
2 Replies
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.