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
jbrooi
Frequent Visitor

Return value for same ID from another row

Hi,

I want to add a new column (see 'Desired' for result), and return the Startdatum for each KandidaatID, when it has a "Gepland" line 

How to do it please, in Power Query? 

 

Ex lookup row.png

 

Thanks! 

1 ACCEPTED SOLUTION
jbrooi
Frequent Visitor
3 REPLIES 3
jbrooi
Frequent Visitor

HotChilli
Super User
Super User

Duplicate the table.

Filter the Geplaatst column to be "Gepland"

Then Perform a Merge (from the ribbon) to the original table joining on KandidaatID.

You can then bring back the date

Thanks, I was hoping to do it in the table itself. It's a large table and coming from a web API which can't load a lot of rows at the same time.. 

Should be possible, right? Tried some solutions but not yet there

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