Forum Discussion
Solved
Compare two text string same field between two different tables to identify Match/No Match
Hi Team, I am trying to compare the Room Name between two tables to Match/No Match. I am using below logic to comapre Room Name field between Table 1 and Table 2 The below query dosen't seems to p...
For your eference.
For your reference.
Validate = IF(MAX('Table 1'[Column4]) = MAX('Table 2'[Column4]),"Match","No Match")
Step 0: I use these data below.
Table 1
Table 2
Step 1: I add a relationship.
Step 2: I make a measure.
Validate = IF(MAX('Table 1'[Column4]) = MAX('Table 2'[Column4]),"Match","No Match")
Step 3: I make a matrix and a table.
Matrix
Table
Sorry, In this sample file column 3 has limited data, it cannot be a unique coumn, because each site may have same room will have same room code accross the floor. So to get a unique column need to add these three Column (1+2+3) (Site+Floor Code+Room Code)
For your reference.
I add a "Key_Column" to the each table and change a relationship.