Forum Discussion
Power Query show only rows with most recent date
- 1 year ago
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]
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]