cancel
Showing results for
Search instead for
Did you mean:
Frequent Visitor

## DAX VLookup help

Hi.

Can someone help me here. I have two tables. Table1 value should try to match with table two.

Table 1 values found in table 2 then yes else no.

Table 1

 123456 yes 456789 yes 741321 No 159753 No 147852 Yes

 Table 2 147852 65 23 123456 456789
1 ACCEPTED SOLUTION
Community Champion

Hi, @Shree185

I assume you want to create a new column in Table1

Please check the below picture and the formula for creating a new column.

New Column =
IF( Table1[Table 1] in VALUES(Table2[Table 2]), "Yes", "No")

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

3 REPLIES 3
Community Champion

Hi, @Shree185

I assume you want to create a new column in Table1

Please check the below picture and the formula for creating a new column.

New Column =
IF( Table1[Table 1] in VALUES(Table2[Table 2]), "Yes", "No")

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

Super User II

you can try this

``````Column =
var lookup=LOOKUPVALUE('Table (2)'[column],'Table (2)'[column],'Table'[Column1])
return if(ISBLANK(lookup),"no","yes")``````

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

Proud to be a Super User!

Helper II

Hello,

Can you create a relationship between both Table1 and Tabl2 and then add a calculated column in Table 1 using "RELATED" fucntion?

Calculated column = if(Table1[Column1]=RELATED(Table2[Column1]),"Yes","No")

Kindly give kudos if my reply helps!

Thanks

## Helpful resources

Announcements

#### Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

#### Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

#### Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors