Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DanFromMontreal
Helper III
Helper III

Adding column using the FILTER function

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?

 

 

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

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

 

View solution in original post

2 REPLIES 2
AlexisOlson
Super User
Super User

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

 

Many thanks @AlexisOlson .

Slipped my mind - I've done this earlier.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors