Having trouble calculating a running total with regular 'corrections'

[Anonymous]

I am tracking a stock. Rough movement to and from the stock gets reported every 12 hours, and there is an irregular stocktake.

I want to calculate a running total, which then gets updated when there is a stocktake survey performed.

I believe I am getting caught up in my 1to1 and 1tomany relationships leading to me using things like LASTNONBLANK incorrectly, and not able to LOOKUPVALUE within my IF statements. I've also attempted to calculate a new column to track the previous day's result, but I run into circular depencies when I try and update that with the stocktake result.

Could someone please advise a good approach to this?

Sample dataset with some of my more basic attempts at calculation in this WeTransfer. https://we.tl/t-TELsXTudH5

[Anonymous]

Hi @Anonymous ,

To my knowledge, your requirement could not be realized currently. Because DAX functions are not support loop call.

Best regards,
Community Support Team_Binbin Yu