Circular dependency on simulation project

[Kev74]

Hello everyone,

I confront a circular dependancy in a project PowerBI during several days, and I can't resolve it.

Here is the subject for understang what I am attempting to do :

Project simulation :

Financial crisis starting in march 2023 & lasts 6 months until september 2023
not able to meet the reimbursement request from clients during the crisis (due to no stuff cut and cash flow problems) 
reimbursement quantities are accumulating. 
The quantity of reimbursement diminishes once sales take off. 

We would be happy to receive recommendations on how to implement this project simulation in power bi, especially column G and H (see screenshot) . Currently, we are having issues of circular dependency and hence we would appreciate any idea on how to implement this in power bi (without using power query). 

Enclosed the Excel file to understand the mechanism (tell me if you have problem comprehension) based on project simulation

Thanks you in advance

[lbendlin]

You may want to continue using Excel for that (unless it also complains about the circulars?).