Forum Discussion
Copying Value From Previous Rows
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.
2 Replies
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 __ResultThanks for the response Greg.
Unfortunately, that only gives the value from the same weekending period.
