Forum Discussion
Circular dependency in Power Bi
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 Av...
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:
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/
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