Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

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

Jihwan_Kim
5 years ago
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

3 Replies

Jihwan_Kim
Super User
5 years ago
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
nilimarodrigues
Helper III
5 years ago
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

Super User

Anonymous

you can try this

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