cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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


Regards

MFelix


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

Proud to be a Datanaut!




View solution in original post

tejapowerbi123 Regular Visitor
Regular Visitor

Re: Lookup using IF or SWITCH

Thank you so much for quick Response.

View solution in original post

2 REPLIES 2
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


Regards

MFelix


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

Proud to be a Datanaut!




View solution in original post

tejapowerbi123 Regular Visitor
Regular Visitor

Re: Lookup using IF or SWITCH

Thank you so much for quick Response.

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)