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.

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

This will only bring today's data though, I still want to see back at least 3 months before today.

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

    Hi, Kmcdonald , here's the specific idea I mentioned before:

    See my visual with dates that are after Today:

    Now, write this measure, put it to the Filter Pane accordingly and you will get dates before today(including today, you can adjust that).

    GetDateFilter = 

IF(MAX('Date'[Date])> TODAY(), 0, 1)