Remove future date from relative date filtering

[diskovered]

I'm using relative date filter to show data: is in this, year

How do I exclude future dates from here? Thanks

[msimmonsmcse]

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]

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 🙂 

[Anonymous]

Thank you @msimmonsmcse  just what I was looking for!

[v-juanli-msft · Accepted solution]

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.

[calerof]

Hi @diskovered ,

You might find this Patrick's Guy in a Cube & @marcorusso's video useful:

Cheers,

Fernando