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.
Id opendate call1start call1end call2 start call2 end call3 start call3 end
001 20220830 14:00 14:02 14:30 14:32 null null
some Ids have 2 calls, some have 3 calls, 4 calls, I hope the table can become
id opendate callstart callend
001 20220830 14:00 14:02
001 20220830 14:30 14:32
002 20220903 15:00 15:24
please help me make it out! Thank you!
Solved! Go to Solution.
Hi, @Anonymous
You can try the following methods. Make a copy of the original table in Power Query. Each table retains one callstart and callend, and the column names are changed to be consistent.
Append two table:
Result:
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
You can try the following methods. Make a copy of the original table in Power Query. Each table retains one callstart and callend, and the column names are changed to be consistent.
Append two table:
Result:
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Oh, you are so smart, and the method is very simple! Thanks a lot!
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.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |