Take data from one table to another

Question

Hello!I have two tables. First have columns Name and Date. Second&nbsp; - 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.&nbsp;Can some one help me to do this ?)

nathaniel_c · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Go to the home tab in Power Query, and select Merge QueriesLet 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
&nbsp;
&nbsp;

anonymous · Answer

I should do it without merges)&nbsp;

nathaniel_c · Answer

Why is that?
&nbsp;

nathaniel_c · Answer

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

v-jingzhang · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;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?&nbsp;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.&nbsp;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&nbsp;NewColumn&nbsp;expand icon and select which columns to add to First Table. You can also add aggregate values in this step.&nbsp;Reference:Merge queries (Power Query) - Excel (microsoft.com)&nbsp;Best Regards,Community Support Team _ Jing ZhangIf this post helps, please consider Accept it as the solution to help other members find it.

Forum Discussion

Take data from one table to another

5 Replies

Related content

Power Query LookUp in another table

[PowerQuery] add (same) column from another table

How to add another column from another table?

merge or update/insert lakehouse table from another lakehouse table

Apply a Slicer from one Table to Another