Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying find a way to transform the columns in a table to rows. (See below example). I need this in individual rows so I am able to build a Process Map with each row as a separate event in the overall process.
Master_id | Assist Id | Begin_Time | Dispatch_Time | End_Time | Technician |
50001 | 7/25/2023 18:23 | 7/25/2023 18:30 | 7/25/2023 17:46 | John Smith | |
50001 | 50002 | 7/25/2023 17:10 | 7/25/2023 17:16 | 7/25/2023 17:46 | Nancy Miller |
Here is what I need the table to look like:
Master_id | Assist Id | Begin_Time | Dispatch_Time | End_Time | Technician |
50001 | 7/25/2023 18:23 | John Smith | |||
50001 | 7/25/2023 18:30 | John Smith | |||
John Smith | |||||
50001 | 50002 | 7/25/2023 17:10 | Nancy Miller | ||
50001 | 50002 | 7/25/2023 17:16 | Nancy Miller | ||
50001 | 50002 | 7/25/2023 17:46 | Nancy Miller |
Solved! Go to Solution.
That seems to be a rather odd format for Power BI. What are you planning to do with the result?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.