Forum Discussion
Solved
4wk moving average per group
hello, I am looking to caluclate 4 week moving average on this data set. I want to get the moving average per platform (group) can someone pls help me how i can do this? you can see the excel tab...
you can also try to this
1. create an order column
order = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Platform]=EARLIER('Table'[Platform])&&'Table'[YYWW*]<=EARLIER('Table'[YYWW*])))2. create 4WMA columnColumn =var _start=if('Table'[order]-3<1,1,'Table'[order]-3)return AVERAGEX(FILTER('Table','Table'[Platform]=EARLIER('Table'[Platform])&&'Table'[order]>=_start&&'Table'[order]<=EARLIER('Table'[order])),'Table'[Value])pls see the attachment below
you can also try to this
1. create an order column
order = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Platform]=EARLIER('Table'[Platform])&&'Table'[YYWW*]<=EARLIER('Table'[YYWW*])))
2. create 4WMA column
Column =
var _start=if('Table'[order]-3<1,1,'Table'[order]-3)
return AVERAGEX(FILTER('Table','Table'[Platform]=EARLIER('Table'[Platform])&&'Table'[order]>=_start&&'Table'[order]<=EARLIER('Table'[order])),'Table'[Value])
pls see the attachment below