Forum Discussion
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?
Thanks!
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
😊
3 Replies
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
😊
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
