Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Solved! Go to 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:
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |