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.
Hello,
I'm trying to compare the running total of two counts, basically when an agreement became effective and then terminated. When I do this, the effective dates work exactly as expected. I run quick measure -> running total -> base value = count of agreement -> Field = effective date (year). However, when I try the same with terminated dates, the graph is completely wonky.
The only thing I can figure that is different between the two is that the "terminated agreements" column has a bunch of empty cells (agreements have not been terminated yet). Any ideas?
Thanks, I'd really appreciate any help!
Solved! Go to Solution.
Solved, using the method from this link.
@Anonymous,
Please share sample data of your table so that we can test.
In addition, you can create your own measure/column to calculate running total instead of using quick measures. This is a similar thread for you reference.
https://community.powerbi.com/t5/Desktop/Cumulative-Total/td-p/43115
Regards,
Lydia
Solved, using the method from this link.
I should add: the "effective agreements" line graph looks as expected, slowly going up as agreements are added. The "terminated agreement" graph is flat, but occasionally bumps up; however, it doesn't seem to bare any relation to actual dates in the original data.
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 |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |