Forum Discussion

pbiforum123's avatar
pbiforum123
Icon for Post Patron rankPost Patron
3 years ago
Solved

Cumulative sum in DAX

We need above output column using DAX. Can someone please share the working DAX.
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    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 👍

DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

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 👍