Forum Discussion
jayjay0306
Helper III
Helper IIIRolling average last 3 months
Hi, I hope you can help me with a shallange: I have a Power BI report, where I need to make a measure (I don't have access to the source table) which calculates the rolling average for the last 3 m...
How about this?
Rolling Average 3 months = VAR LastDate_ = LASTDATE ( Table[Calendar Day] ) RETURN CALCULATE ( AVERAGEX ( VALUES ( 'Table'[Month] ); CALCULATE ( SUM ( 'Table'[Sales] ) ) ); FILTER ( ALL ( Table ); [Calendar Day] <= LastDate_ && [Calendar Day] > DATEADD ( LastDate_; -3; MONTH ) ) )Similar to yours, but i changed the table for AVERAGEX to iterate over to the month values. Also changed the calcualte filter a little bit.
Excellent Ulf, that solved it 🙂
Thanks.
How about this?
Rolling Average 3 months =
VAR LastDate_ =
LASTDATE ( Table[Calendar Day] )
RETURN
CALCULATE (
AVERAGEX ( VALUES ( 'Table'[Month] ); CALCULATE ( SUM ( 'Table'[Sales] ) ) );
FILTER (
ALL ( Table );
[Calendar Day] <= LastDate_
&& [Calendar Day] > DATEADD ( LastDate_; -3; MONTH )
)
)
Similar to yours, but i changed the table for AVERAGEX to iterate over to the month values. Also changed the calcualte filter a little bit.
