Forum Discussion

jamuka's avatar
jamuka
Helper IV
6 years ago

Circular Dependency

Hello,     I tried to create a stock report, based on stock quantity and forecast amount on Store/Warehouse level. Numbers should change based on selection, e.g product x could have an 1000 total...
Need Help
Tips and Tricks
jamuka's avatar
jamuka
Helper IV
6 years ago

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

v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

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. 

 

 

  • jamuka's avatar
    jamuka
    Helper IV
    6 years ago

    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