Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm making a calculated column to check if to columns in different tables are equal. This is the statement I have made but the second table is grayed out.
Location PK = IF(LEFT(Table1[whe],2) = "PK" & Table2[whe] = "PK", "Y","N")
Thanks in advance!
Solved! Go to Solution.
Hi @Anonymous ,
If you want to compare two columns, maybe you could try to use the RELATED function. If you want to compare the specific values in the two columns, you could use the LOOKUPVALUE function.
I made two formulas that you can reference.
Note: We need to create a relationship between the tables.
RELATED = IF(RELATED('Table 1'[Name]) = 'Table'[Item],"Yes","No") LOOKUPVALUE = IF(ISBLANK(LOOKUPVALUE('Table'[Item],'Table 1'[Name],"A")), "No", "Yes")
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
Hi @Anonymous ,
If you want to compare two columns, maybe you could try to use the RELATED function. If you want to compare the specific values in the two columns, you could use the LOOKUPVALUE function.
I made two formulas that you can reference.
Note: We need to create a relationship between the tables.
RELATED = IF(RELATED('Table 1'[Name]) = 'Table'[Item],"Yes","No") LOOKUPVALUE = IF(ISBLANK(LOOKUPVALUE('Table'[Item],'Table 1'[Name],"A")), "No", "Yes")
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
hi,
what are you looking for?
which row context are you comparing to which row?
prehaps you can attached an example
regards