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.
DateBridge = VAR TodayMonthYr = VALUE(FORMAT(today(),"YYYYMM") VAR EndMonthYr = VALUE(FORMAT([End],"YYYYMM") RETURN IF( AND( EndMonthYr > TodayMonthYr - 3 , EndMonthYr < TodayMonthYr + 6 ), "Yes" , "No" )