cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tejapowerbi123 Regular Visitor
Regular Visitor

Lookup using IF or SWITCH

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User
Super User

Re: Lookup using IF or SWITCH

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




tejapowerbi123 Regular Visitor
Regular Visitor

Re: Lookup using IF or SWITCH

Thank you so much for quick Response.

2 REPLIES 2
Highlighted
Super User
Super User

Re: Lookup using IF or SWITCH

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




tejapowerbi123 Regular Visitor
Regular Visitor

Re: Lookup using IF or SWITCH

Thank you so much for quick Response.