Forum Discussion
Solved
Power Query | How to remove (older) duplicate records
Hi once again, How do you recommend to remove an older version of a record. I plan to use the file created date as the time stamp to tell which record is newer. Here's a dummy data: Co...
In power query (get data) sort by the date column descending. Then select all columns except date and select remove rows\remove duplicates.
In power query (get data) sort by the date column descending. Then select all columns except date and select remove rows\remove duplicates.
I see, so it does have that behavior. thanks MattAllington