First post here! I’m loving the tutorials which I’m powering through. In the meantime, I am really stuck on a circular dependency problem and am hoping you guys can help me out or point me in the right direction as I’m still very early on my Power BI journey.
I have a table with Opening Debtor Balances and a table with Sales Invoices & Credit Notes. I would like to take Balance (at last month end) + sales - receipts = Balance. The problem I have is that Balance is based on an older Balance thus causing a circular reference.
How can I get I fix this?
Ending Balance = if([myDate]<DATE(2018,05,01), [Opening Balance], [Ending Balance LM] + [Sales]+[Receipts by Allocation Date])
So May 2018 Ending Balance should be 15,294,457.73 and June 14,858,118.51