Forum Discussion
Running total not working for one column?
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!
- Anonymous7 years ago
Solved, using the method from this link.
3 Replies
- AnonymousNot applicable
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.
- AnonymousNot applicable
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- AnonymousNot applicable
Solved, using the method from this link.