Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

30 day rolling average

Hi   Would anyone be able to help me convert this formula into a "last 30 day rolling average"? I seem to be going in circles.   Thank you in advance!   Turnover Rolling Avg. Calc. (€) = AVE...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    I think you can try this code.

    Turnover Rolling Avg. Calc. (€) 2 =
CALCULATE (
    AVERAGE ( onetouch_daily_account_summary_last_2_months[bet_eur] ),
    FILTER (
        ALL ( 'Calendar' ),
        'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
            && 'Calendar'[Date]
                > MAX ( 'Calendar'[Date] ) - 30
    )
)

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Samarth_18  So now there is no error message, but the result is blank. hmm.

 

i did have to change the reference for this part, to the column, and not the measure, for it to accept it.  

 

AVERAGE ( onetouch_daily_account_summary_last_2_months[Turnover (€)] )
 
changed to 
 
AVERAGE ( onetouch_daily_account_summary_last_2_months[bet_eur] )