Circular dependency how to solve calculus

[Syndicate_Admin]

Hello

I have to calculate the flow balances, I want to do it dynamically, however the system gives me circular dependency when I get the value of a cell from the previous context that I am evaluating and assign it as a new value in the Initial Balance cell. Formulas are calculated the final balance but the final balance of one month is the initial balance of the next and must be added to the final balance of the next month. I've tried to solve it with cheating measures to call the final and initial balance calculation elsewhere but it's always circulating, you know how to solve it:

[Anonymous]

Hi @Syndicate_Admin ,

You may take a look at this blog.

https://community.powerbi.com/t5/Community-Blog/Iteration-in-DAX/ba-p/1223311 

Best Regards,

Jay

[aj1973]

Hi @Syndicate_Admin 

Check this out, is good

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/