Forum Discussion
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.
The table
the measure ==>
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.
