Power Query show only rows with most recent date

[nok]

Hello!

In PowerQuery, I'm trying to do a filter to show only the most recent files based on the column "Folder Patch.2.1", but I don't know how to do it. Here's how the data appears:

In the example image above, I want to always filter ONLY the files with the "Folder Patch.2.1" column with the most recent date. In this case, it would only show these rows:

How can I do this?

[mickey64 · Accepted solution]

For your reference.

Step 0: I use these data below.

Step 1: I click a right button of mouse on 'Folder Path.2.1' and select 'Group By...'.

Step 2: I enter the conditions in the "Group By" window and click the OK button.

Step 3: I expand the "Date created" column.

Step 4: I add a condition column.

Step 5: I filter the 'Flag' column.

Step 6: I remove these columns.

[Before]

[After]

[lbendlin]

Click the dropdown, sort the column descending

Group by folderpath.2.1

keep top row

ungroup