topic Re: Cumulative total by multiple column in DAX Commands and Tips

Cumulative total by multiple column

Anonymous — Sat, 31 Oct 2020 16:00:27 GMT

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

Re: Cumulative total by multiple column

Fowmy — Sat, 31 Oct 2020 16:09:30 GMT

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

Re: Cumulative total by multiple column

Anonymous — Sun, 01 Nov 2020 16:11:30 GMT

Fowmy

see the below image