Forum Discussion
Solved
Retrieve multiple column values from another table based on value in initial table?
Hi all, Is there an easy way I can get multiple values deom a second table based on a value in the first table? I both tables I have a value (Line Number) and I would like to get several colu...
Create a New Calculated Table
FilteredTable =
SELECTCOLUMNS(
FILTER(
TableB,
TableB[Line Number] IN VALUES(TableA[Line Number])
),
"Line Number", TableB[Line Number],
"Column1", TableB[Column1],
"Column2", TableB[Column2]
// Add more columns as needed
)
Create a New Calculated Table
FilteredTable =
SELECTCOLUMNS(
FILTER(
TableB,
TableB[Line Number] IN VALUES(TableA[Line Number])
),
"Line Number", TableB[Line Number],
"Column1", TableB[Column1],
"Column2", TableB[Column2]
// Add more columns as needed
)