Forum Discussion

giuliapiazza94's avatar
giuliapiazza94
Helper 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/


     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

giuliapiazza94 In your first query, add a Merge Query step in Power Query Editor to merge the second table on the customer columns.

 

  • giuliapiazza94's avatar
    giuliapiazza94
    Helper IV
    4 years ago

    I can't use Power Query because I haven't direct access to customer's database.

    I need to do this using only DAX