cancel
Showing results for
Did you mean:
Frequent Visitor

## Rolling average

Hi

Can anyone see whats wrong with this formula? id like to get a 30 day rolling average, but i saw this online and tried to use it, just to get any kind of rolling average for now. but the result i get from this is the same number as teh Turnoer number, not an average at all.

Any ideas?

Turnover 30D Avg. = CALCULATE(
AVERAGEX(
FILTER(ALLSELECTED('Calendar'),
'Calendar'[Date] <= MAX('Calendar'[Date])),
onetouch_daily_account_summary_last_2_months[Turnover (€)])

)
1 ACCEPTED SOLUTION
Super User

If Turnover is a column rather than a measure, I think you should put the CALCULATE inside the AVERAGEX iterator in order to do the context transition.

Turnover 30D Avg. =
AVERAGEX (
FILTER (
ALLSELECTED ( 'Calendar' ),
'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
),
CALCULATE ( onetouch_daily_account_summary_last_2_months[Turnover (€)] )
)

3 REPLIES 3
Frequent Visitor

@AlexisOlson - just a follow up question if i may, how can i make this formula (which works fine) to be a 30 day average. at the moment its pulling the default total from the data set so id like to restrict this to Last 30 days only please.

Frequent Visitor

@AlexisOlson  thank you for the reply, it works great now. much appreciated!

Super User

If Turnover is a column rather than a measure, I think you should put the CALCULATE inside the AVERAGEX iterator in order to do the context transition.

Turnover 30D Avg. =
AVERAGEX (
FILTER (
ALLSELECTED ( 'Calendar' ),
'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
),
CALCULATE ( onetouch_daily_account_summary_last_2_months[Turnover (€)] )
)

Announcements