Cumulative total with 3 conditions

[Siriwat_Lukin]

Hello everyone,

I want to calculate daily cumulative total by daily , person and sub assembly. 

by have data as below ( yellow column is expect result)

I've been trying to find examples and fix myself for a long time.

Could you please help me to solve this ?

Thank in advance

[negi007 · Accepted solution]

@Siriwat_Lukin I have attempted to solve your problem.

Here we go

1. Create a calculated column in your data to concatenate your columns values which will be used to calculate cumulative total

Concatnate_col = 'Cumulative _Total'[Date] &"|" & 'Cumulative _Total'[Person Name] & "|" & 'Cumulative _Total'[Sub-assembly]

2. Then using Quick Measure you can create a running total measure which is basically your cumulative total like below

3. Create below visual to show cumulative total

I hope this solution works for you

[Siriwat_Lukin]

Hello,

I can solve this problem.

Thank you for your solution and I think it's good idea.

😊