When you removed duplicates from a table, which record does it keep?

[Anonymous]

I have a dimension table and sometimes a duplicate creeps in so I have a de-dup step. However, is it keeping the top-most record? Or bottom? Or is there other logic involved?

I ask because, if I filter date descending so I have the most recent records at the top, then de-dupe, can I safely tell my customers they are seeing the most recent version of that record? 

[Anonymous]

Ahh fabulous @amitchandak - table.buffer to force a sort by, or grouping my max date! How could I have overlooked this option. Thanks this article was exactly what I needed.

[amitchandak · Accepted solution]

@Anonymous , I think you need to follow this approach

https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/