Calculated columns across tables

[JamesBockett]

Hello

How do you do a 'not equal to' across tables?

I have 2 tables. Table 1 has columns: Unique ID, Field A & Field B.

Table 2 has Unique ID only. 

I need to create a column in Table 2 that returns "Pass" or Fail", depending on what is in Table 1, Field A and Field B. For example:

if Table 1[Field A] equals "1" or "2" or "3" or "4" and Table 1[Field B] does not equal "1" then "Fail"

OR

if Table 1[Field A] does not equal "1" or "2" or "3" or "4" and Table 1[Field B] does equal "1" then "Fail"

Thankful for any help

[AlexisOlson · Accepted solution]

Is this along the lines you're looking for?

Pass/Fail =
VAR A = LOOKUPVALUE ( Table1[FieldA], Table1[ID], Table2[ID] )
VAR B = LOOKUPVALUE ( Table1[FieldB], Table1[ID], Table2[ID] )
RETURN
    IF (
        ( A IN { "1", "2", "3", "4" } && B <> 1 ) ||
        ( NOT ( A IN { "1", "2", "3", "4" } ) && B = 1 ),
        "Fail",
        "Pass"
    )