Forum Discussion
AlessandroBet
Helper V
Helper VSet a filter with a date created with measure
Hi,
i need to set a filter with a date created with measure.
ex: Today +90 = TODAY()+90
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)
3 Replies
vicky_Super User
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)
AlessandroBetthank you i did it but i can't use it as filter
- AlessandroBet
What i need is to set a date +90days and this filter has to change every day reading the date of today