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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI

 

Calculate(sum(value),allexcept(Table[EndofMonth]))

  • Murali777's avatar
    Murali777
    Helper III
    4 years ago

    Hi James,

     

    I have tried, but it is not working. if you dont mind pls share the PBIX file.

    Thanks.