Forum Discussion

analystict's avatar
analystict
Helper I
7 years ago
Solved

Circular dependency in a calculated column.

Hey there,   I have a table called Invoices which looks like this:   AccountID | Date | InvoiceID | Amount | ProductID | InvoiceNum | Product 1 | 02/12/01 | 153452C | 500 ...
Need Help
  • Nolock's avatar
    Nolock
    7 years ago

    Hi,

     

    please could you post the error message? I've tried to build the same 2 tables and new computed columns like you have but I don't have any errors.

    The only thing I did additionally was adding another column InvoiceNumPackage3 which shows the Rank of InvoiceNumPackage2 only on rows which contains the Product 9.

     
    InvoiceNumPackage3 = 
IF(
    Invoices[Product] = "Product 9"; 
    Invoices[InvoiceNumPackage2]; 
    BLANK()
)
analystict's avatar
analystict
Helper I
7 years ago

Thanks!

 

However, the error was different. After looking into it slightly more I found an active relationship between the invoices table and another table which probably caused the circular dependency, now everything seems in order.

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

analystict ,

 

Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.