Forum Discussion

Anonymous's avatar
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 ...
Need Help
  • Jihwan_Kim's avatar
    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

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

Anonymous 

you can try this

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