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])))
HavenerTed's avatar
HavenerTed
Advocate I
4 years ago

Hello all,

 

I was wonderfing if there is a way to get the cumulative column by employee and/or project number? RIght now I have the cumulative column which generates a sum much greater than it should be but when it is in measure format it works correctly. Essentially, I am trying to cumulative hours per employee instead of the whole entire company.

 

Let me know what you may have to help.

 

Thank you.