topic Re: Merge query with dax in DAX Commands and Tips

Merge query with dax

giuliapiazza94 — Wed, 17 Nov 2021 15:37:12 GMT

Hi,

I have two tables like

I'd like to have the values "Farm" in the first table using DAX.

How can I to do?

Thank you all 🙂

Re: Merge query with dax

Greg_Deckler — Wed, 17 Nov 2021 15:48:39 GMT

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

Re: Merge query with dax

giuliapiazza94 — Wed, 17 Nov 2021 15:53:06 GMT

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

I need to do this using only DAX

Re: Merge query with dax

smpa01 — Wed, 17 Nov 2021 16:04:00 GMT

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])

Re: Merge query with dax

giuliapiazza94 — Thu, 18 Nov 2021 07:46:42 GMT

I've tried but i've this error

but there is a relationship 1:m between two tables

Re: Merge query with dax

VahidDM — Thu, 18 Nov 2021 07:52:48 GMT

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/

Re: Merge query with dax

Anonymous — Tue, 23 Nov 2021 08:11:36 GMT

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.