Forum Discussion
JamesGordon
Helper II
Helper IIMerging 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.
ahmedoye
Responsive Resident
Responsive ResidentHi 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.