Forum Discussion

mmace1's avatar
mmace1
Icon for Impactful Individual rankImpactful Individual
5 years ago

Creating a new column, and setting it = an old column, is causing a Circular Dependency Error. Why?

I was trying to help a colleague (clearly I am not qualified to). They're getting a circular dependency error.

 

In testing, I notice, that say - they have Column A in Table_1.

 

I fI create Column B, with simply the formula Column B = Table_1[column A]. This causes Column B to give a circular dependency error.

 

Now, Column A is a ridiculous column, but I don't understand how simply referencing it, in a brand new column, is triggering a circular dependency error?

 

That 'Column A' for reference (which I'll clean up with SWITCH for them anyway)

 

 

Matrix_Acct_Type = 
VAR MATRIXACCTTYPE =
IF (
    LOOKUPVALUE ( Customer[CustNBR], Customer[CustNBR], SFDC_Opportunity[CustNBR] )
        = BLANK (),
    (
        IF (
            SFDC_Opportunity[Product] = "AP Assist",
            "Auto",
            IF (
                SFDC_Opportunity[Sales Team] = "Automotive",
                "Auto",
                IF (
                    CONTAINSSTRING ( SFDC_Opportunity[Channel Partner], "CDK" ),
                    "Auto",
                    IF (
                        SFDC_Opportunity[OwnerId] = "005A0000005JRpZIAW",
                        "Auto",
                        IF (
                            ISBLANK (
                                LOOKUPVALUE (
                                    SFDC_Account[Sub Industry],
                                    SFDC_Account[AccountId], SFDC_Opportunity[AccountId]
                                )
                            ),
                            "Standard",
                            IF (
                                CONTAINSSTRING (
                                    LOOKUPVALUE (
                                        SFDC_Account[Sub Industry],
                                        SFDC_Account[AccountId], SFDC_Opportunity[AccountId]
                                    ),
                                    "Automotive"
                                ),
                                "Auto",
                                "Standard"
                            )
                        )
                    )
                )
            )
        )
    ),
    IF (
        LOOKUPVALUE (
            Customer[CustProductType],
            Customer[CustNBR], SFDC_Opportunity[CustNBR]
        ) = "AP Assist",
        "Auto",
        IF (
            LOOKUPVALUE ( Customer[SFOwner], Customer[CustNBR], SFDC_Opportunity[CustNBR] ) = "Pam Cichoke",
            "Auto",
            IF (
                CONTAINSSTRING (
                    LOOKUPVALUE (
                        Customer[ChannelPartner],
                        Customer[CustNBR], SFDC_Opportunity[CustNBR]
                    ),
                    "CDK"
                ),
                "Auto",
                IF (
                    CONTAINSSTRING (
                        LOOKUPVALUE (
                            Customer[OrgSubIndustry],
                            Customer[CustNBR], SFDC_Opportunity[CustNBR]
                        ),
                        "Automotive"
                    ),
                    "Auto",
                    "Standard"
                )
            )
        )
    )
)
RETURN MATRIXACCTTYPE

 

1 Reply

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support

    Hi, mmace1 

     

    In theory, Column B = Table_1[column A] is fine. Can you share some sample data and describe the logic of Matrix_Acct_Type? I can try to simplify and modify the formula for you.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.