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 ...
I have already uploaded a SQL data, how can I create a function to sort the column order and force de removing to follow the date sort? I dont know how to create the function...
It is sad PBI dont "follow" the sort order to eliminate duplicates...