Forum Discussion
Circular Dependency
Hi jamuka
This is a good refresher on circular dependencies: https://www.sqlbi.com/articles/understanding-circular-dependencies/.
Power BI does not allow to have two calculated columns that contain measures that are also based on that table. In order to understand why, you'd need a better understanding of what's going on under the hood.
Hi v-diye-msft,
I read it but all I understand from it is, that I can not use a measure in a calculated colum, but didn't understand how to avoid it.
I'm trying to create a new table and will make my measure in it, then make my calculated columns in current table, maybe it will work.
thanks
Hi jamuka
If you'd like to avoid the Circular Dependency error, please :
1. Use measure instead of a calculated column.
2. If the calculated column is bound needed, please create it in power query using M code.
3. Create a NEW table that manages the relationship between them, that not all calculated column fetches the data in the same table.
BTW, there no [Days] column in your sample that results in many formula errors.
Hi v-diye-msft,
yes you are right about [Days] column, before I upload my sample, I simplfied and translate it ( I forgot to translate Days Column) normally it didn't cause a problem. I updated my file thank you.
I create a new table with product and Stock/Days column but because there's no location information in my new table I can't slice it correctly.
about your soluitions;
2 - I don't need to use calculated columns, my power bi knowledge is limited therefore I use it.
1 - I don't know how to use "IF" formulas in measures (e.g IF (Table[ColumnName] = "x")
3 - I don't understand how to do it?
kind regards
