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...
Need Help
Tips and Tricks
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

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

      Noone? 

      • v-chenwuz-msft's avatar
        v-chenwuz-msft
        Icon for Community Support rankCommunity Support
        4 years ago

        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.