Forum Discussion
Solved
Dax Running Total matrix
Friends, Can u help me to write the dax code for running total matrix.See my requirement
pls try this
Measure = calculate(COUNTROWS('Table'),FILTER(all('Table'),'Table'[Date]<=max('Table'[Date])&&'Table'[Status]=max('Table'[Status])))ryan_mayu Thanks
pls try this
Measure = calculate(COUNTROWS('Table'),FILTER(all('Table'),'Table'[Date]<=max('Table'[Date])&&'Table'[Status]=max('Table'[Status])))ryan_mayu Thanks
you are welcome
ryan_mayu , How we can implement this running total is no data available on a particular month
for eg Jan 5 feb no data available and march 5, so running total of march will be 10
I tried some ways , but all failed. I am also interested in this topic. So I rasied a similar post for searching the solutions.
https://community.powerbi.com/t5/Desktop/Running-total/m-p/2022833#M759984
Two experts provided the solutions.
Thanks for asking the further question and I also learned a lot.