Forum Discussion
Power Query show only rows with most recent date
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?
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]
2 Replies
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]
Click the dropdown, sort the column descending
Group by folderpath.2.1
keep top row
ungroup
