cancel
Showing results 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.

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

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.

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

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")``````

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

Announcements