Forum Discussion

MikeBar15's avatar
MikeBar15
Frequent Visitor
3 years ago
Solved

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...
Need Help
  • MikeBar15's avatar
    MikeBar15
    3 years ago

    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.  

MikeBar15's avatar
MikeBar15
Frequent Visitor
3 years ago

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.