Cumulative total by multiple column

[Anonymous]

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

Business	Business1	Business2	year	Month	Quarter	Value
A	C	E	2019	Jan	Q1	10
B	C	F	2019	April	Q2	15
B	D	E	2019	July	Q3	12
A	D	F	2019	Oct	Q4	12
B	C	E	2020	Jan	Q1	15
A	C	F	2020	April	Q2	20
A	D	E	2020	July	Q3	23

[Fowmy]

@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]

@Fowmy 

see the below image