Reply
Visitor
Posts: 1
Registered: ‎11-19-2018
Accepted Solution

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!

 

 

 

 


Accepted Solutions
Highlighted
Member
Posts: 50
Registered: ‎05-30-2016

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

 

View solution in original post

Community Support Team
Posts: 3,808
Registered: ‎07-09-2016

Re: Cumulative Total

@fviz,

 

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.

View solution in original post


All Replies
Highlighted
Member
Posts: 50
Registered: ‎05-30-2016

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
Posts: 3,808
Registered: ‎07-09-2016

Re: Cumulative Total

@fviz,

 

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.