Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 provide the desired output. I need which Room Name is same will be "Match" and if not then it will be "No Match"
Table 1 Table 2
1. Site Code 1. Site Code
2. Floor Code 2. Floor Code
3. Room Code 3. Room Code
4. Room Name 4. Room Name
5. Validate 5. Validate
Thanks,
Solved! Go to Solution.
did you have any relatioship between these two tables?! from which table did you use column 1, column2, column3 in visual and why?!
To create a unique column, I need to combine Column(1+2+3) to create a relation between these two Table 1 & Table 2
For your reference.
Validate = IF(MAX('Table 1'[Column4]) = MAX('Table 2'[Column4]),"Match","No Match")
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)
when I use larger set of data, this query is not working.
Hi @toovishant
in this case it seems that lookupvalue can perform better. then you can write as follows:
Validate =
VAR _Table2RoomName = LOOKUPVALUE(Table2[Column4], Table2[Column4], Table1[Column4])
RETURN IF(
Table1[Column4] = _Table2RoomName,
"Match",
"No Match"
)
If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.
@Selva-Salimi - Thanks for the reply
when i use lookupvalue it doesn't recognize Table1[column4] or vise versa. Please can you show by using the sample table and execute this query.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |