Forum Discussion
MTD average
I want to have a MTD calculation and a MTD average thru the month. I can get a MTD with TOTALMTD function, but I have no clue on how to divide this MTD on the day of the month to get the average. I...
Noone?
Hi Peavey ,
Maybe you can try this expression:
AvgMTD =
CALCULATE(AVERAGE('Table'[Quantity Produced]),all(),DATESMTD('Table'[Date]))Result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.