Forum Discussion
pbiforum123
Post Patron
Post PatronCumulative 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
- DOLEARY85
Resident Rockstar
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 👍