Forum Discussion
Solved
Cumulative sum in DAX
How to get the output column in dax
We need above output column using DAX. Can someone please share the working DAX.
Hi,
try this:
Running Total (m) =CALCULATE(SUM ( 'Table'[Sales] ),FILTER(ALL('Table'),'Table'[Employee] = MAX('Table'[Employee])&&'Table'[Date]<=MAX('Table'[Date])))If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
1 Reply
Hi,
try this:
Running Total (m) =CALCULATE(SUM ( 'Table'[Sales] ),FILTER(ALL('Table'),'Table'[Employee] = MAX('Table'[Employee])&&'Table'[Date]<=MAX('Table'[Date])))If I answered your question, please mark my post as solution, Appreciate your Kudos 👍