Resetting a running total in the same column

[Ackbar-Learner]

Hi I am doing a Balance Sheet and i want a running total to reset. I cannot get the running total to reset at Capital and Reserves

Below are some columns that I created to identify where to reset. When calcType changes, the running total should reset.

I cannot get my brain around to write this DAX code 🤔

[Ackbar-Learner · Accepted solution]

I am closing this one. I figured it out eventually! Running totals cannot be reset in the same column. I had to do another running total column and use SWITCH to get the best of the two columns.