Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
106 | |
87 | |
77 | |
69 |
User | Count |
---|---|
124 | |
112 | |
94 | |
84 | |
75 |