Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
Hi fviz,
See this image and tell us if works for you (I used a similar file I had)
@Anonymous,
Add an index column in Query Editor and use Quick measure Running total.
@Anonymous,
Add an index column in Query Editor and use Quick measure Running total.
Hi fviz,
See this image and tell us if works for you (I used a similar file I had)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |