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
amitchandak
Super User
Super UserAnonymous , 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