Cumulative sum in DAX

[pbiforum123]

How to get the output column in dax

We need above output column using DAX. Can someone please share the working DAX.

[DOLEARY85 · Accepted solution]

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 👍