Forum Discussion

diskovered's avatar
diskovered
Helper III
7 years ago
Solved

Remove future date from relative date filtering

I'm using relative date filter to show data: is in this, year   How do I exclude future dates from here? Thanks
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi diskovered 

    The video shared by calerof is helpful.

    For your secenario, you could create another measure, then put it in the visual levle filter

    Measure = IF(MAX('Table'[Date])<=TODAY(),1,0)

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

msimmonsmcse's avatar
msimmonsmcse
Helper I
6 years ago

Problem with this accepted solution is that it can only be used at the visual level. I used the same code, only in a calculated column in my date table. It can be used a filter for a page, all pages or visual:

 

Date-Filtered = IF ( 'Table'[Date]'<=TODAY(), 'Table[Date]', BLANK())

The BLANK() function makes sure there is no value in the column for furture dates in table. 

bwarner87's avatar
bwarner87
Advocate I
3 years ago

thanks for adding your thoughts. This was exactly what I needed in order to filter on pages for CY and PY but still allow my date table to have years in the future for forecasting 🙂