Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Quick measure - Moving average

Hello,   I'm new with power BI and i have trouble calculating moving average.   I use the quick measure option to calculate 3 month moving average and i get this result:         It seems...
Need Help
Show and Tell
Tips and Tricks
  • ChandeepChhabra's avatar
    ChandeepChhabra
    7 years ago

    You can write something like

    =IF( [OtherMeasureInChart]<>Blank(), [Rolling Avg Measure] )

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

Thanks for your answer. It's not working as the rolling average for march is equal to march data. The calculation seems to begin in march 2016.

 

ChandeepChhabra's avatar
ChandeepChhabra
Impactful Individual
7 years ago

Anonymous

I am not sure if I have understood your question correctly.

 

When you say remove the first 2 months - You mean still want the rolling total to start from Jan but don't want to show Jan and Feb in horizontal axis of the chart ?

 

Can you please elaborate ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    ChandeepChhabra

     

    Well what i want is to show a good calculation of the rolling average. With my formula the calculation only begin in march, so the rolling haverag is equal to march value. For April the calulation is (march + april)/2 wich is still incorect.

     

    To have what i want i need to begin my measure at this date (2015;10;1) to have the rolling average for january. So is it possible to hide 2015?

     

    Thank you for your precious help

    Martin