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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
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.