Hi @judy_fmf
PFB solution for your requirement.
I’m just showing past 3years data. If you want you can change the Variable PY.
3Y Same period =
VAR SM =
SELECTEDVALUE ( ‘Dates Disconnected’[MonthName] )
VAR SY =
SELECTEDVALUE ( ‘Dates Disconnected’[Year] )
VAR PY = 3
VAR Sameperiod =
FILTER (
Dates,
( Dates[Year] > SY - PY
&& Dates[Year] <= SY )
&& Dates[MonthName] = SM
)
RETURN
CALCULATE ( [Total Sales], Sameperiod )
