Forum Discussion

Peavey's avatar
Peavey
Icon for Helper III rankHelper III
4 years ago

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 am struggling with this, help please. 

Simple dataset below to show the needs.

 

 

Thanks

-A-

Need Help
Tips and Tricks

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Peavey , I case you need average of sum of daily

     

    MTD = CALCULATE(AverageX(values('Date'[Date]), calculate(SUM(Table[Qunatity Produced])) ),DATESMTD('Date'[Date]))

    • Peavey's avatar
      Peavey
      Icon for Helper III rankHelper III
      4 years ago

      amitchandak Yes, average sum of MTD on the current day.

       

      I tried your formula but did not get an average, just the same MTD value, see picuture:

       

       

      Thanks