Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.