Forum Discussion

Kmcdonald's avatar
Kmcdonald
Icon for Helper III rankHelper III
4 years ago
Solved

Relative Date - Using Now/Today Function

Hi, Does anyone know a way to filter a relative date using a now function or column?   I have got some DAX that counts rows, based on a Calendarauto function. The issue is that is counts for dat...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Try this measure

    =if(min(calendar[date])>today(),blank(),[your measure])

    To the X-axis of your graph, please drag Date from the Calendar Table.

vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
4 years ago

Hi, Kmcdonald 
The easiest solution is to write a calculated column or measure that will check the current day and return 1 or 0 (or whatever) for days before today. Then you go to the Filter pane and put the column or measure to filter that visual and you select that you want to display only data that have the result 1.