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:
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: