Forum Discussion

sridharpolina's avatar
sridharpolina
Icon for Helper I rankHelper I
4 years ago
Solved

Relative date filtering including future dates

Hi, I am trying to dynamically filter a date which includes future dates as well. For Ex. For March 2022 I need a query which looks at the previous 12 months and the next 12 months (March2021-March20...
DAX
Desktop
Show and Tell
  • johnt75's avatar
    johnt75
    4 years ago

    You could add a column to your date table for filtering purposes, something like

    Within 24 month window =
var startDate = EOMONTH( TODAY(), -13) + 1
var endDate = EOMONTH( TODAY(), 12 )
return IF( 'Date'[Date] >= startDate && 'Date'[Date] <= endDate, 1, 0)

    then add that filter to your visuals

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

You can achieve a solid+dashed appearance by stitching two measures together so that one (past data) stops where the other (future data) begins.

 

Please provide sanitized sample data that fully covers your issue.

Please show the expected outcome based on the sample data you provided.