Using an If statement to check 2 columns in two tables are equal

[Anonymous]

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!

[v-xuding-msft · Accepted 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.

[YJ]

hi,

what are you looking for? 

which row context are you comparing to which row?

prehaps you can attached an example

regards