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.

5 Replies

  • 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 🙂 

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    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.