How to add another column from another table?

[BAFreedom]

I have two tables, both have 1 common column that can be linked to each other.

Example:

Table 1 Columns: Item, Date of Purchase, Customer, Item ID

Table 2 Column: Item ID, Price, Effective Date

How do I create a query, such that I add 1 column from the 2nd table to the 1st table? Kind of like a VLOOKUP in excel.

Example here: is to add price (from table 2) into Table 1.

Thank you.

[FreemanZ · Accepted solution]

you can add a new column in Table1 with the code below:

Price2 = RELATED(Table2[Price])

or you want a query for a complete new table, try to create a new table with this:

Table3 =

ADDCOLUMNS(

    Table2,

    "Price2",

     RELATED(Table2[Price])

)

[aj1973]

Hi @BAFreedom 

In case you want to use DAX, watch this video

https://www.youtube.com/watch?v=6_O3UDKOVHo&t=3s

But if you want to use Power Query Editor to merge Columns and/or tables

https://www.youtube.com/watch?v=y3bOyNpJuXc