Reset cumulative sum when sum of values is negative

[mahsan_ojaghian]

Hi Guys!

I want to do cumulative sum on a calculate column and

I want it resets when sum of values is negative and starts

with the positive value when meets a negative one.

I'll be happy if somebody have an idea!!!

AND it would be the best if you have a DAX formula!!!!

Thanks.

[jirojo92]

Hi, I am currently facing the same problem, and despite looking for a solution for a long time, I have not found any.

I need a cumulative sum, that does not go below 0. I need to control stock, and it does not make sense for me to have a negative stock, as my demand that is not fulfilled, can not be recovered later.

Did you manage to find a solution?

[v-xiaotang]

Hi @mahsan_ojaghian 

Thanks for reaching out to us, I find a post Solved: Running total by group with a reset - Microsoft Power BI Community

does it help?

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@mahsan_ojaghian , refer if the old solution can help

https://community.powerbi.com/t5/Desktop/Consecutive-sum-for-the-positive-and-negative-values/m-p/23...

If this does not help
Can you share sample data and sample output in table format?

[mahsan_ojaghian]

Thanks.

but it did'nt work for me.