Forum Discussion
How to remove duplicates based on sort order
When loading the data I need to keep only the latest record. I don't have a date to rely on to determine the latest record but I have a status, based on which I can sort in a somewhat chronological ...
We also had a similar problem. We found this solved our problem:
1. Sort data as required
2. Add index column starting at 1
3. Remove Duplicates
The index column helps Power BI realise while removing duplicates that there is a specific order to the sorted data.