Rolling average but it is more complex ...

[Anonymous]

Hey Power BI Users! This is my first question here. 

I am an absolut beginner in Power BI but this system is awesome. I need your help and count on you!

My problem is the rolling average - I have the monthly average:

Average (monthly) = (DIVIDE('Parts per Month'[DoAs]; [Count of Parts]))*100+0

I need to 6 und 3 month rolling average. Currently I just filter the monthly average to the last 6 and 3 months but like you see in the pictures this is not the right way. I trieded and watched many videos about that topic but without success. 

Rolling Average 3 Months = calculate(SUMX(VALUES(Dates[Date]);'Stammdaten Komplett'[cases per month]); DATESINPERIOD(Dates[Date]; MAX(Dates[Date]); -3; month))/3  - this gives not the right data (is just an average of the last 3 months - i need a rolling average). 

Thank you for the help!

[amitchandak · Accepted solution]

@Anonymous , rolling seems fine. But calculation should be like this ?

Rolling Average 3 Months = calculate((DIVIDE('Parts per Month'[DoAs]; [Count of Parts]))*100; DATESINPERIOD(Dates[Date]; MAX(Dates[Date]); -3; month))

[Anonymous]

Thank you!