DAX VLookup help

[Anonymous]

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

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

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

[ryan_mayu]

@Anonymous 

you can try this

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

[nilimarodrigues]

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