Forum Discussion
Helper VFind matching value in another table and return with text string
Hi all,
I've been looking around but couldn't find the simple solution to my work. So I have 2 tables and I need to perform lookup.
If table1[Item] = table[Item] then it is "match"
| Table 1 |
| Item |
| Car |
| Table 2 |
| Item |
| Car |
Apologies, I'm not understanding this I feel, but if you want to know if there is a match in another table, you could do this:
Column = IF(COUNTROWS(FILTER(ALL('Table2'),'Table2'[Item] = [Item]))>0,"Match",BLANK())
4 Replies
- Greg_Deckler
Community Champion
In general you would use LOOKUPVALUE to do this work or perhaps you could just relate the two tables. I don't think there is enough information presented to truly understand what you are trying to accomplish.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
StuznetSo basically, I need to perform lookupvalue in both tables, if it is the same then return text string "Match"
- Greg_Deckler
Apologies, I'm not understanding this I feel, but if you want to know if there is a match in another table, you could do this:
Column = IF(COUNTROWS(FILTER(ALL('Table2'),'Table2'[Item] = [Item]))>0,"Match",BLANK())