Compare two values based on a related value

[Niniat]

I've got two tables related by ID# (TBL1[ID] *:1 TBL2[ID]) and want to compare the Location column in each table and return a true or false if they match

example:

TBL1

ID          Location

1            A

2            B

3            C

TBL2

ID          Location

1            D

2            B

3            C

In table 1 I want to add a column that will tell me a True if the location in table 2 for the ID matches the location in table 1 for the ID and a False if it doesn't.

Thanks!

[PhilipTreacy · Accepted solution]

Hi @Niniat 

This will create your column

Match = IF(RELATED('TBL2'[Location]) = TBL1[Location] , TRUE, FALSE)

regards

Phil

[Niniat]

@PhilipTreacy Thank you!! My error was in putting the tables in the wrong order... Thank you so much!