Remove duplicates - keeping the most recent row

[Anonymous]

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 · Accepted solution]

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.

[Anonymous]

Indeed i only readd the solution 😉 Thanks !