Forum Discussion
Helper IIIRemove 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
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
MaggieCommunity 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
msimmonsmcseHelper I
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.Thank you msimmonsmcse just what I was looking for!
- bwarner87
Advocate I
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-msftCommunity Support
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
MaggieCommunity 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.- calerof
Impactful Individual
Hi diskovered ,
You might find this Patrick's Guy in a Cube & marcorusso's video useful:
Cheers,
Fernando
