how to keep the latest row when delete the duplicated row

[yanzhao_LBS]

when i did the remove row- remove duplicates , the earlist one will be kept,but i want to keep the latest one which is the one i need. how to achieve that?

[Ritaf1983 · Accepted solution]

Hi @yanzhao_LBS 
You need to sort in the wanted order before removing the action.

Also, you need to modify your m code to keep the sort order.

Please refer to the linked tutorial

https://www.youtube.com/watch?v=rqDdnNxSgHQ

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983 · Accepted solution]

Hi @yanzhao_LBS 
You need to sort in the wanted order before removing the action.

Also, you need to modify your m code to keep the sort order.

Please refer to the linked tutorial

https://www.youtube.com/watch?v=rqDdnNxSgHQ

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[yanzhao_LBS]

Thanks for your response, but i cannot open the youtube ,can you give some doc link for the m code? as I have tried the sort,but it seems not work maybe need the 'm code ' you mentioned.

[Ritaf1983 · Accepted solution]

@yanzhao_LBS 
This document explains the issue and you can download the sample from it :
https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/

[yanzhao_LBS]

Thanks for your help again ,it really works for me.

[Ritaf1983]

Happy to help 🙂