Find matching value in another table and return with text string

[Stuznet]

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

[Greg_Deckler]

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

[Stuznet]

So basically, I need to perform lookupvalue in both tables, if it is the same then return text string "Match"

[Greg_Deckler · Accepted solution]

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())

[Stuznet]

Thank you so much @Greg_Deckler.