Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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.

 

 

 

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's avatar
    Anonymous
    7 years ago

    Hi fviz,

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

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi fviz,

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