Cumulative Total

[Anonymous]

Hi guys,

I'm in trouble to create a measure "cumulative total" that cumulates the number of employees in my department. If someone leaves I want the number to go down. In the following picture I created a test table to see if it works.

Now I want a column next to it with the following numbers:

1

2

1

2

1

2

1

I already tried the formula described on

https://www.daxpatterns.com/cumulative-total/

but it doesn't work for me. Can someone help me please?

Thanks in advance!

[Anonymous · Accepted solution]

Hi fviz,

See this image and tell us if works for you (I used a similar file I had)

[v-chuncz-msft · Accepted solution]

@Anonymous,

Add an index column in Query Editor and use Quick measure Running total.

[Anonymous · Accepted solution]

Hi fviz,

See this image and tell us if works for you (I used a similar file I had)