Forum Discussion

newgirl's avatar
newgirl
Post Patron
4 years ago
Solved

Cumulative Total in Calculated Column

Hello! I have sample table below and I tried to make a calculated column to compute for the cumulative total per Count grouping per month. Below is my screen shot of my PBIX where the results do not...
Need Help
  • newgirl's avatar
    newgirl
    4 years ago

    I was able to use this formula:

    Cumul = 
CALCULATE(SUM('Table'[SubTotal_Vol]),
FILTER(ALLEXCEPT('Table','Table'[Merged]), 'Table'[Date]<= EARLIER('Table'[Date]) && 'Table'[Merged] <= MAX('Table'[Merged])))
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi newgirl - I think you need

VAR _Date = MAX([Date]) 
ALLSELECTED()

REMOVEFILTERS([Date])

FILTER (  [Date] <= _Date)