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/


     

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

giuliapiazza94  you can create relationship between t1 and t2 through Customer column and then you can create a calculated column in t1 like following

Farm from t2 = RELATED(t2[Farm])
giuliapiazza94's avatar
giuliapiazza94
Icon for Helper IV rankHelper IV
4 years ago

I've tried but i've this error 

but there is a relationship 1:m between two tables