5 Rolling Average previous weekoffset -2 to weekoffset -6

[yellow_old_5]

Hello everyone , I need help to create a variance measure for 8 Rolling week from offset -1 to offset -8.

ex , see table below:

Thanks

[amitchandak · Accepted solution]

@yellow_old_5 , You can use the window function with -8 , rel, -1,rel

refer

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc

Power BI Webinar- How to take advantage of New Power Bi Functions Offset,Window, Index:
https://youtube.com/live/exk8F5ka1Nw