Forum Discussion

Niniat's avatar
Niniat
New Member
2 years ago
Solved

Compare two values based on a related value

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!

 

  • Hi Niniat 

     

    This will create your column

     

     

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

     

     

    regards

     

    Phil

     

2 Replies

  • Hi Niniat 

     

    This will create your column

     

     

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

     

     

    regards

     

    Phil

     

    • Niniat's avatar
      Niniat
      New Member

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