Forum Discussion
Cumulative Total with Dynamic Parameter Boundaries
Hi all. I'm new to PowerBI and and having troubling with a cumulative total when trying to add dynamic conditionals. Here's a sample execl snip of what I'm trying to achieve (or download the...
Thank you again tamerj1
I understand cumulative total now, but am still having an issue with the bounded_cumulative.
I've managed to get some circular reference errors while trying to account for the previous row.
For example. The second bounded cumulative should be 0 + 5, since the first cumulative was -1 it is replaced with bound_min (0).
Any idea how to get to that? I need to calclate the cumulative (previous cumulative + measure1), check it is within bounds, assign the value or bound, move to the next row and repeat.
Cheers