Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date filter

I have date fields like below, in this date visual how can i restrict the from and to date. From date is a standard one(say 2021-05-25) and to date is getdate. Thanks      
  • PaulOlding's avatar
    PaulOlding
    5 years ago

    You could add a measure to use in the visual level filter.

    Display Date =
    VAR _CurrentDate = MAX('Date'[Date])
    VAR _Result = IF(_CurrentDate >= DATE(2021, 5, 25) && _CurrentDate <= TODAY() , 1, BLANK())
    RETURN
    _Result
     
    then set the filter to 'is 1'

     

PaulOlding's avatar
PaulOlding
Icon for Solution Sage rankSolution Sage
5 years ago

You could add a measure to use in the visual level filter.

Display Date =
VAR _CurrentDate = MAX('Date'[Date])
VAR _Result = IF(_CurrentDate >= DATE(2021, 5, 25) && _CurrentDate <= TODAY() , 1, BLANK())
RETURN
_Result
 
then set the filter to 'is 1'