Forum Discussion
Helper IVCircular Dependency
Community SupportHi 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.
Helper IVHi 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