Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |