Remove duplicates but leave the record with the most recent date

[Syndicate_Admin]

Hello friends.

I need to remove duplicates from a table, but leave the record that has the most recent Valuation Date.

example:

The beneficiary JOSE ORBEGOZO, appears 2 times, with valuation dates of March 19 and May 10.

When removing duplicates, the most recent date should remain: May 10.

The table has more than 11 records with many duplicate values.

I need to do this in the Power Query, so that when you loaded it into the Power Bi, the table is ready.

or... is there any option to do it in a calculated table directly on the Power Bi?

Thanks a lot.

[v-yalanwu-msft]

Hi, @Syndicate_Admin ;

Have ryan_mayu’s reply helped you to find the solution to this problem?  I also think that group by is more suitable for this case, and I made a simple sample based on your data, as follows：

If so, would you like to the helpful replies as a solution so that others can learn from it and close this topic?
Thanks in advance!

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Thanks a lot. This is indeed a solution. I have been very supportive of your support.

[ryan_mayu]

@Syndicate_Admin 

you can try group by in the PQ.

grouping the all the columns except the date column, then do the Max operation on the date column

[amitchandak · Accepted solution]

@Syndicate_Admin , refer if this blog can help

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

[Syndicate_Admin]

Thank you, it has helped me too.