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 column values based on the Line number vale in Table one.#
Soi if Table A has a Line Number value 12345-678 then I would like my table to show maybe 2/3 column values where the Line Number value in Table B is also 12345-678
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
)
4 Replies
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
)you can try to merge queries in PQ
https://learn.microsoft.com/en-us/power-query/merge-queries-overview?wt.mc_id=DP-MVP-5004616
Thank you
Thank you - worked perfectly
