cancel
Showing results for
Did you mean:
Frequent Visitor

## Calculated columns across tables

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

1 ACCEPTED SOLUTION
Super User

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"
)``````
Super User

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"
)``````

Announcements