Forum Discussion
Solved
Merging table info
Hi, I have two tables and i am looking to combine some of the infomation. Essentially table 1 contains a small list of "stock number" and "outstanding amounts" and table 2 contains contains h...
Hi JamesGordon
Do you have one-to-one relationships between table1 and table2 by [Stock Number] field?
if so, you dont even need to code smth - just add columns from table 2 to visual
Hi JamesGordon , You can add extra columns in your Table 1 with:
Model = RELATED(Table2[Model])Customer = RELATED(Table2[Customer])That ofcourse, assuming your tables have 1 to 1 Relationships. In which case, you can also do as suggested by az38 .
If those suggestions work for you, kindly mark them as solutions to enable others benefit from them.
Hi JamesGordon , You can add extra columns in your Table 1 with:
Model = RELATED(Table2[Model])
Customer = RELATED(Table2[Customer])
That ofcourse, assuming your tables have 1 to 1 Relationships. In which case, you can also do as suggested by az38 .
If those suggestions work for you, kindly mark them as solutions to enable others benefit from them.
If those suggestions work for you, kindly mark them as solutions to enable others benefit from them.