Retrieve multiple column values from another table based on value in initial table?

[BarryFletcher]

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

[BarryFletcher]

Thank you - worked perfectly

[ryan_mayu]

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

[BarryFletcher]

Thank you

[Kedar_Pande · Accepted solution]

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
)