cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Cumulative Total

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.

 

testv01.png

 

 

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!

 

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: Cumulative Total

Hi fviz,

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

 

Zähler.JPG

 

Community Support Team
Community Support Team

Re: Cumulative Total

@Anonymous,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Highlighted
Anonymous
Not applicable

Re: Cumulative Total

Hi fviz,

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

 

Zähler.JPG

 

Community Support Team
Community Support Team

Re: Cumulative Total

@Anonymous,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.