Forum Discussion
ovetteabejuela
Impactful Individual
Impactful IndividualPower 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.
MattAllington
Community Champion
Community ChampionIn power query (get data) sort by the date column descending. Then select all columns except date and select remove rows\remove duplicates.
ovetteabejuelaImpactful Individual
Impactful IndividualI see, so it does have that behavior. thanks MattAllington