Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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
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