How to reset running total when the value is greater than 0

[Anonymous]

Hi, 

I would like to aks for help.

I have calendar, daily transactions and annulted daily transactions table in my model. 

Do you have any ideas how to create running totals measure , but with resetting when the "daily balance " > 0?

Additional : I will use date slicer to select needed dates in the report.

Thank you in advance for your cooperation.

Best Regards, 

[Ashish_Mathur]

Hi,

Please also show the expected result.

[Anonymous]

Hi, 

Thank you for your prompt reaction 🙂 

The expected result is :

Best Regards, 

[Ashish_Mathur]

Hi,

I am still not clear with the logic of the last column.  Can you restate the logic in simple English.

[Anonymous]

Hi, 

Of cource. 

The logic is as follow: when the daily balace is positive the amount should be paid , so it becomes 0. But when we have a negative daily balace it should be reset with subsequent positive daily balances or if the next daily balances are negative to accumulate until offset wit positive ones.

Best Regards, 

[Ashish_Mathur]

Hi,

I can try to help.  Share the link from where i can download your PBI file.

[Anonymous]

Hi, 

https://www.dropbox.com/s/dua64b9g0nmvaxi/Daily_Balance.pbix?dl=0

Thank you in advace 🙂

Best Regards, 

[mh2587]

Expected Result = IF([daily_balance] < 0 , [daily_balance] , 0)

 Put this measure I think it will resolve your issue

[Anonymous]

Hi, 

This will not work because when it is a negative value it should be accumulated ( with next negative value) and reset with a next positive value.