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])))
newgirl's avatar
newgirl
Post Patron
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])))
  • majos978's avatar
    majos978
    Frequent Visitor
    2 years ago

    Hi! I am wondering, what is the Merged variable that you are using in your solution?

    • newgirl's avatar
      newgirl
      Post Patron
      2 years ago

      Hello! The Merged column is the merging of 2 columns in which how I grouped them. For example, I consider INLAND100 as one group, RETAILER327 as another, which helped compute for the cumulative for that group.