Return value for same ID from another row

[jbrooi]

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? 

Thanks! 

[jbrooi · Accepted solution]

Searched some more and found the solution

https://community.powerbi.com/t5/Power-Query/Return-a-Value-based-on-other-rows/m-p/2774682#M86016

😊

[HotChilli]

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

[jbrooi]

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