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.
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!
Solved! Go to 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
😊
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
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.