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.

Murali777's avatar
Murali777
Helper III
4 years ago

Hi Esha,

 

Is any input on the below scenario please?

 

Murali777's avatar
Murali777
Helper III
4 years ago

Below is the code for the output Esha.. We need to filter based on the User right. it works fine. 

 

Thank you for your help as well.

 

MonthlyTotal1 = CALCULATE(SUM(EmployeeTable[Value]),ALLSELECTED(EmployeeTable[User]))