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 dates past today and looks pretty bad on my line graph (see below).I have been experimenting with the Now and Today function but can't get it to show only values on or before that date.Seeing if anyone has a solution on this 🙂

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.

Relative Date - Using Now/Today Function | Microsoft Fabric Community

vojtechsima
Super 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.
Ashish_Mathur
Super 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.
Kmcdonald
Helper 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
  Super 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)