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] )

ChandeepChhabra's avatar
ChandeepChhabra
Impactful Individual
7 years ago

You can write something like

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Your simple trick saved my day..

Thanks mate