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:
| Color | Shape | Material | Stored |
| Red | Circle | Wood | 7/2/2017 |
| Red | Circle | Metal | 7/2/2017 |
| Red | Circle | Wood | 7/1/2017 |
| Yellow | Circle | Wood | 7/4/2017 |
So the plan is to remove record #3 because it is an older version of record #1, the "Store" column should tell when it was stored.
In power query (get data) sort by the date column descending. Then select all columns except date and select remove rows\remove duplicates.
2 Replies
- MattAllington
Community Champion
In power query (get data) sort by the date column descending. Then select all columns except date and select remove rows\remove duplicates.
- ovetteabejuela
I see, so it does have that behavior. thanks MattAllington
