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)
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

what doesn't work, write how it doesn't work

  • Rickstor's avatar
    Rickstor
    Frequent Visitor
    3 years ago

    your solution almost work. Look:

    In a excel I have this:

    The moving average just go on through the years. 

     

    Using your solution in DAX I have this (I think that is because effect of evaluation context):

    Sorry. Was my fault. In my original post I didn't show the other years. 

    How to fix?