Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

cumulative average by month

Hi,

ActualDate - Amount

10/22/16 $1000

10/23/16 $1100

10/25/16 $ 900

11/01/16 $1000

11/11/16 $1100

11/21/16 $1200

12/01/16 $400

12/28/16 $500

I want to do avarage monthly, which is 1000 for Oct/2016, 1100 for Nov/2016, 450 for Dec/2016. Then accumulate current month average and averages of the months before current month. The visual should be like:

I googled a lot, but almost scenaria is discussing doing average such as totalAmount/monthAmount.

Thanks in advance.

  • Hi,

     

    Try the solution provided here and see if it works for you

    Rolling average

    You might need to change the base value of the quick measure to:

     

     

2 Replies

  • Hi,

     

    Try the solution provided here and see if it works for you

    Rolling average

    You might need to change the base value of the quick measure to:

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Gordonlilj, thanks a lot!

      Solution let me learn a lot such as datebetween, summarize, thanks again.