Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |