Forum Discussion
NenadV
Helper III
Helper IIIRemoving duplicates after sorting does not work as expected
So I have key column and a date column and i am trying to keep only last date for every key. I first sort by key column and then by date column descending, and everything is looking fine. But when I ...
HI NenadV ,
There is an existing thread for this. Chek this if it helps:
https://community.powerbi.com/t5/Desktop/Keep-only-the-latest-date-for-duplicate-entries/td-p/638447
Thanks,
Pragati
try this
Table.Group(yourTabName, {"key"}, {{"LastDate", each List.Last(_[date])}})
Pragati11
Super User
Super UserHI NenadV ,
There is an existing thread for this. Chek this if it helps:
https://community.powerbi.com/t5/Desktop/Keep-only-the-latest-date-for-duplicate-entries/td-p/638447
Thanks,
Pragati