Forum Discussion
Filter top 5 earliest dates from a column in Power Query
In Power Query, I'm trying to filter my 'Date Created' column to show the longest running CI Intiatives (aka the ones with the earliest date created) but I can only see how to filter it the single most earliest and not for the top 5 earliest Date Created?
You can sort by the column and then do a 'Keep rows' , specifying the number of rows (This creates a Table.FirstN command)
1 Reply
- HotChilli
Community Champion
You can sort by the column and then do a 'Keep rows' , specifying the number of rows (This creates a Table.FirstN command)