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.

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.