Power Query | How to remove (older) duplicate records

[ovetteabejuela]

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.

[MattAllington · Accepted solution]

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