Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Cumulative total by multiple column

 

Hi all,

 

i need cumluative/running total of an table with multiple columns,

 

I have try this formula but that want be correct:

 

Total = CALCULATE(SUM('Table'[Value]), FILTER(ALLEXCEPT('Table', 'Table'[Business ], 'Table'[Business1 ], 'Table'[Business2 ]), 'Date'[Date] <= EARLIEST('Date'[Date])))
 
when i select 2019 Q2  ,business i need cummulative total of the value
 
Anyone who can help me is very grateful 
 

 

Table looks like this

 

BusinessBusiness1Business2yearMonthQuarterValue
ACE2019JanQ110
BCF2019AprilQ215
BDE2019JulyQ312
ADF2019OctQ412
BCE2020JanQ115
ACF2020AprilQ220
ADE2020JulyQ323
Need Help
Show and Tell
Tip & Tricks

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

    Can you share the expected result and explain a bit more?

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Fowmy 

       

      see the below image