Circular dependency in Power Bi

[Anonymous]

The data is entered on every Friday. The input format is as shown above.
The required output on power bi is shown below.

When I try to make measures for Cash on Hand, Total Cash Available and Cash Position, it says circular dependency. 
Link to excel file: https://docs.google.com/spreadsheets/d/1T81swf2pX2B2VdBEf1PGbDViHZOV6-v6E6rDQWAq0is/edit?usp=sharing 
Please help me to my find a solution.
Thanks in advance 🙂

[luapdoniv · Accepted solution]

If I understand correctly, you are looking to bring in the closing cash as the opening cash of following week and not get into the calc on circular dependency. This is similar to the inventory model where we bring in the Closing Stock of previous period as the Opening Stock of next period. You can apply the logic found in this link to get to the solution:

https://community.powerbi.com/t5/Desktop/DAX-to-Calculate-Opening-and-Closing-Stock-including-Previo... 

Hope this helps.

[amitchandak]

@Anonymous , I am not able to see the formula of Cash on Hand, Total Cash Available, can you provide those

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

[Anonymous]

Cash on Hand = Cash Postion of previous week
Total Cash Available = Cash on Hand + Total Cash Recipets
Cash Position = Total Cash Available - Total Cash Paid Out