Forum Discussion

Murali777's avatar
Murali777
Helper III
4 years ago
Solved

Monthwise total using DAX

Hi,   Below is my request to figure out the MonthwiseTotal column using DAX measure. I have tried using TotalMTD function but it is working. Can any one pls help on this.    
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    The table

    the measure ==>

     

  • Anonymous's avatar
    Anonymous
    4 years ago

    hi Murali777 

     

    You can use this measure

    MonthwiseTotal = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[End Of Month]))
     

    If this post helps, accept it as a solution.

TomMartens's avatar
TomMartens
Super User
4 years ago

Hey Murali777 

 

this article Time patterns – DAX Patterns contains almost everything you need to know to create time/date related calculations.

It's necessary that you create a dedicated calendar table and then create a measure that cumulates the values from all the data less and equal to the selected date.

 

Hopefully, this helps to tackle your challenge.

 

Regards,

Tom