Take data from one table to another

[Morfin]

Hello!

I have two tables. First have columns Name and Date. Second  - Name, Date, Money.

In Power Query i need to make user functions which from second table add column Money in first table.

It is look like vlookup.

Can some one help me to do this ?)

[Nathaniel_C]

Hi @Morfin ,

Go to the home tab in Power Query, and select Merge Queries


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

 

[Morfin]

I should do it without merges)

[v-jingzhang]

Hi @Morfin 

Could you please let me know why you don't want to use merge? Is your data structure a little special so Merge Queries is not applicable to it?

Per my understanding, merge queries is the simplest way to realize your requirement. With a merge query, you can achieve similar goals to the Excel VLOOKUP function.

You can select First Table in the Queries and click Merge Queries to get new columns into First Table. In Merge window, you can select one or multiple columns to match rows. In the following image, I select Name and Date columns to match with. After merging, you can click the NewColumn expand icon and select which columns to add to First Table. You can also add aggregate values in this step.

Reference:

Merge queries (Power Query) - Excel (microsoft.com)

Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[Nathaniel_C]

Why is that?

[Nathaniel_C]

You might try this https://community.powerbi.com/t5/Desktop/M-Query-lookupvalue/td-p/830337