Forum Discussion
Circular dependency error... from data in a same column?
Anonymous , You can not same column in power bi like excel.
Also, you can not use the last row of the column you are building.
you can use it earlier to work across rows. You can use a cumulative formula to get data
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Sure! Here's the Power BI document where the data and the calculated column are included.
Accountability System Prototype
An observation of the data is the following:
- In the data we have "AccountNumber" and "AccountNumberAffected", the first one is the ID of an account and the second one is the corresponding ID of the account that affects. For example: If I have operations with the account "240" then I know that it will affect the result from the account "200".
Knowing this, here's the next thing:
- The user can enter a "BeginningBalance" for a specific account, if we don't have a user input then by default the beggining balance is "0".
And finally, what I want to do is this:
- Knowing that we have user inputs and "0" values in the "BeginningBalanceUserInput" field, in the calculated column I want to do two things: IF the "BeginningBalanceUserInput" is not "0" then just put the same value given, but if it's "0" then SUM the "BeginningBalanceUserInput" values knowing that one account affects the other depending on their corresponding IDs.
Thank you 😄