Compare current year 3-month rolling average to last year's 3-month rolling average

[medzabad]

This year's rolling calc works fine, but need to get average for same 3 month period last year.

Rolling  3 = CALCULATE(AVERAGE(Census[Census]),DATESINPERIOD('DimDate'[Date],ENDOFMONTH(Census[CensusDate]),-3,MONTH))

Ultimate goal:  Need to get last year's 3-month rolling average, which I will then use to compare to this year's 3 month rollilng average to get a variance %, which I will then use that variance % to increase/decrease my current month, day, week, etc... 

Thanks in advance for your help!

[Ahmedx · Accepted solution]

pls try

Rolling  3 last year = 
VAR _Last = DATEADD(
DATESINPERIOD('Calendar'[Date],ENDOFMONTH(Census[CensusDate]),-3,MONTH),-1,YEAR)
RETURN
CALCULATE(AVERAGE(Census[Census]),_Last)

[medzabad]

Thanks much!  It works as expected!  😊