Forum Discussion
5 Rolling Average previous weekoffset -2 to weekoffset -6
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
Anonymous , 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
1 Reply
- amitchandak
Super User
Anonymous , 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