Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@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
Thanks for the response Greg.
Unfortunately, that only gives the value from the same weekending period.