Set a filter with a date created with measure

[AlessandroBet]

Hi,

i need to set a filter with a date created with measure.

ex: Today +90 = TODAY()+90

[AlessandroBet]

What i need is to set a date +90days and this filter has to change every day reading the date of today

[AlessandroBet]

thank you i did it but i can't use it as filter

[vicky_ · Accepted solution]

If you have a date table, you can use something like:
DateFilter = IF(SELECTEDVALUE(DateTable[Date]) <= TODAY()+90, 1)

and use this in your filters (both through the filter pane by dragging the measure into the pane, or as a calculate parameter)