How to add another column from another table?

Question

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 Answer

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

)

Forum Discussion