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...
Need Help
  • Gordonlilj's avatar
    Gordonlilj
    7 years ago

    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:

     

     

Gordonlilj's avatar
Gordonlilj
Icon for Solution Sage rankSolution Sage
7 years ago

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
7 years ago

Gordonlilj, thanks a lot!

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