2

Goal: I am trying to filter a line chart that has trends both 3 months back and 6 months out (a total of a 10 month block).

Attempted Method: I tried to create a binary DAX-based yes/no filter as a column in a selected query based on the End date column.

I have the code for my attempt at creating this formula shown below.

My code:

DateBridge = 
VAR TodayMonthYr = VALUE(FORMAT(today(),"YYYYMM") 
VAR EndMonthYr = VALUE(FORMAT([End],"YYYYMM")

RETURN 
IF(
   AND(
       EndMonthYr > TodayMonthYr - 3 , 
       EndMonthYr < TodayMonthYr + 6
   ),
   "Yes" , "No"
)
Ethan
  • 1,657
  • 9
  • 25
  • 39
naridox
  • 21
  • 3

0 Answers0