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 ...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    2 years ago

    Hi Niniat 

     

    This will create your column

     

     

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

     

     

    regards

     

    Phil

     

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
2 years ago

Hi Niniat 

 

This will create your column

 

 

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

 

 

regards

 

Phil

 

Niniat's avatar
Niniat
New Member
2 years ago

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