Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 click on remove duplicates, it does not remove rows that I wanted to remove, for some keys it remove wrong rows.
Here is screenshot of table, after sorting, everything seems fine. I marked rows that are expected to be removed after I click on remove duplicates(based on key column).
But, instead row number 3 from first screenshot, row number 2 is removed.
Please, can someone explain me what is going on here?
Solved! Go to Solution.
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])}})
try this
Table.Group(yourTabName, {"key"}, {{"LastDate", each List.Last(_[date])}})
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |