Forum Discussion

Helper I

3 years ago

Solved

How to add another column from another table?

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...

Need Help

FreemanZ
3 years ago
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])
)