Forum Discussion
Filtering Column Date (Latest and Second to Latest)
I am able to filter a date column by selecting the filter icon in the column, placing my mouse over "Data Filters" and selecting "Is Latest." However, I also need the second to latest in that column. Any methods to get to this result?
I ended up finding a work around. I needed to edit this data in Power Query so that I could model the data from the latest date available and second latest date available.
First, I duplicated the query after I had filtered by latest date to isolate the latest date data.
Second, I removed the filtered by latest date and filtered by "Is not latest" and then filtered by "is latest" to get the second latest date.
2 Replies
Hi MikeBar15 ,
Here is my sample:
Please try:
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I ended up finding a work around. I needed to edit this data in Power Query so that I could model the data from the latest date available and second latest date available.
First, I duplicated the query after I had filtered by latest date to isolate the latest date data.
Second, I removed the filtered by latest date and filtered by "Is not latest" and then filtered by "is latest" to get the second latest date.
