Copying Value From Previous Rows

[ShaneL79]

Hello Everyone,

I have what I hope is a simple problem for you experts. 

I have a table visualization similar to the image below (minus the final two columns).

We develop a weekly report using the "WeekEnding" date. I have a rolling average which compares the previous 12 months and provides the average number of events over that time (re: [Events (Rolling AVG - Current Year)]). 

The column [Events (Rolling AVG - Previous Year)] should be simply a copy of the value from the [Events (Rolling AVG - Current Year)] but 52 weeks prior. I can't figure out how to just start copying from 52 rows prior. 

Any ideas?

Thank you.

[Greg_Deckler]

@ShaneL79 Maybe:

Measure =
  VAR __WeekEnding = MAX('Table'[WeekEnding])
  VAR __PrevYearWeekEnding = __WeekEnding - 52*7
  VAR __Table = ADDCOLUMNS( { __PrevYearWeekEnding }, "__Value", [Events (Rolling AVG - Current Year)] )
  VAR __Result = MAXX( __Table, [__Value])
RETURN
  __Result

[ShaneL79]

Thanks for the response Greg.

Unfortunately, that only gives the value from the same weekending period.