Forum Discussion

giuliapiazza94's avatar
giuliapiazza94
Icon for Helper IV rankHelper IV
4 years ago
Solved

Merge query with dax

Hi,  I have two tables like  1    2   I'd like to have the values "Farm" in the first table using DAX. How can I to do?   Thank you all 🙂  
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi giuliapiazza94 

     

    try this to add a new column in table 1:

    Farm = LOOKUPVALUE('Table 2'[Farm],'Table 2'[customer],'Table 1'[Customer])
     
     
    output:
     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/


     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi giuliapiazza94 ,

 

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

 

Hope it helps,


Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.