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()
)
Nolock's avatar
Nolock
Resident Rockstar
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.