Forum Discussion

Rickstor's avatar
Rickstor
Frequent Visitor
3 years ago
Solved

Moving Average 5 periods

Hello. Please help me. I need a moving average, 5 periods, in Power BI, using a measure. This is so easy in Microsoft Excel. I need this:   The column 'year' has a text format.   After se...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

    5 step 3 = 
VAR _CurentRx = MAX('data'[Rx])
VAR _Results = CALCULATE(SUM(data[value]), FILTER(ALL(data),'data'[Rx]<=_CurentRx&&'data'[Rx]>=_CurentRx-4), VALUES(data[cod_region])) /5
RETURN
IF(_CurentRx< 6 , BLANK(),_Results)
Rickstor's avatar
Rickstor
Frequent Visitor
3 years ago

Thank you.