Forum Discussion
Solved
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 t...
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