Adding column using the FILTER function

[DanFromMontreal]

Good day,

I'm wanting to add a column using the FILTER function (type of Vlookup) but do not how to proceed in Power Query.

I therefore add this Excel function outside my query to look for the value in the column "PROG" and return the "NumSystSource" (just like a vlookup).

                                      =FILTER(tblProgSystSource[NumSystSource];[@Prog]=tblProgSystSource[Prog])

How do I integrate that in my query???

Any thought?

[AlexisOlson · Accepted solution]

In the Power Query, this can be done with a merge where you match on the [Prog] columns from each table.

https://docs.microsoft.com/en-us/power-query/merge-queries-overview

[DanFromMontreal]

Many thanks @AlexisOlson .

Slipped my mind - I've done this earlier.