Monthly rolling average

[Almantas32]

Hey guys, 

I wanted to calculate the monthly rolling average of completed tasks, using the same formula I used for weekly average. But something is off and it does not work for moths in the same way. 

I am Attaching a link to file as an example:

https://drive.google.com/file/d/1TNMMGjRvBQi9M65z1UkKt2vmCk_dikgI/view?usp=sharing

Should i modify the formula or go with a different one for moths completely? 

[amitchandak]

@Almantas32 , I checked the file. what is expected output?

[Almantas32]

Hey, 

the problem is the rolling average (yellow line) in upper chart should show a rolling average all months + current. Instead it shows the sum off tasks that month. 

I use the same formula for weeks in the chart below and it works. 

[amitchandak · Accepted solution]

@Almantas32 ,

Try like

Tasks Monthly Average = CALCULATE(AVERAGEX(VALUES('Calendar Tasks'[Month Name]), [Total Tasks Done]),FILTER(ALLSELECTED('Calendar Tasks'), 'Calendar Tasks'[Month Name] <= MAX('Calendar Tasks'[Month Name])))

Some changes will be need in case you get additional data