Lookup using IF or SWITCH

[tejapowerbi123]

Hi,

Can you please review below scenarios and provide your suggestion/s?

I have two tables and both tables are not connceted with any relationship

If table 1 country name column match with table 2 country name then comments should be “DEALER”.

Table 1 (Look Up Table)

Country Name

Brazil

Ecudor

Peru

Mexico

Table 2
Country Name	Comments
Brazil	Dealer
Ecudor	Dealer
Peru
Mexico	Dealer

Thanks

[MFelix · Accepted solution]

Hi @tejapowerbi123,

In your sample data the full dataset is on both tables so the result would be Dealer in all rows.

Add the following column to your table 2:

Dealer = IF(LOOKUPVALUE(Table1[Country Name];Table1[Country Name];Table2[Country Name]) <>BLANK() ;"DEALER")

Regards,

MFelix

[MFelix · Accepted solution]

Hi @tejapowerbi123,

In your sample data the full dataset is on both tables so the result would be Dealer in all rows.

Add the following column to your table 2:

Dealer = IF(LOOKUPVALUE(Table1[Country Name];Table1[Country Name];Table2[Country Name]) <>BLANK() ;"DEALER")

Regards,

MFelix

[tejapowerbi123 · Accepted solution]

Thank you so much for quick Response.