Forum Discussion
BAFreedom
Helper I
Helper IHow 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...
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])
)
FreemanZ
Super User
Super Useryou 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])
)