Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table with duplicates in Column A. I want to remove the duplicates based on the date in column B, keeping the most recent record. I've sorted by = Table.Sort(#"Reordered Columns1",{{"Column A",Order.Ascending},{"Start Date", Order.Descending}}) so the most recent record is listed first.
But when I remove duplicates in column A in the next step after sorting, it is not necessarily keeping the newest record.
I've looked at other posts along these lines and some people were able to use Group By, while others talked about buffering the table before removing the duplicates. How should I remove duplicates so that the newest record remains?
TIA
Solved! Go to Solution.
Probaby a couple ways to handle this, but here's what I did:
Table.FirstN( [AllDate],1)
Here's the pbix file:
sorry about that. can you see if this one works
Hi,
Here is also a link explaining the solution using Table.Buffer: https://www.youtube.com/watch?v=S3X_HK7yl1w&ab_channel=PragmaticWorks.
It worked well for my case.
BR
Probaby a couple ways to handle this, but here's what I did:
Table.FirstN( [AllDate],1)
Here's the pbix file:
@Anonymous is there any possiblity you could upload the pbix file again? Unfortunately in a transition I lost the file and really like to keep it for reference.
Many thanks
I get this message when I navigate to it:
sorry about that. can you see if this one works
do you mind resharing your pbix file please?
hello, would you happen to have this PBIX file available that I can have it as well? I am running into a little problem at the end that I am not sure if I did anything wrong. The file would be much appreciated. Thanks a lot
Hi,
Share your data and show the expected result.
Oh gosh, thank you!! This is an invaluable example!
Thank you so much for walking me through it! Appreciated immensely!
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |