Forum Discussion

ZubinB's avatar
ZubinB
Frequent Visitor
1 year ago
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...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    ZubinB 

     

    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
     
ZubinB's avatar
ZubinB
Frequent Visitor
1 year ago

Hi Abhilash_P  

Thank you for taking the time in answering the question.

It didn't return any error but it dint give any numbers. it created 4WMA column with blanks.

what am i doing wrong? sorry im a beginner in powerbi..

 

 

Thanks