Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
76 | |
60 | |
53 |
User | Count |
---|---|
165 | |
86 | |
68 | |
68 | |
58 |