Forum Discussion
Monthly rolling average
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?
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
3 Replies
Almantas32 , I checked the file. what is expected output?
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.
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
