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
)
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