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 convert this to two rows:
So that it looks like this:
I've tried the usual 'group by' and pivoting, but I've got stuck!
I've also been experimenting with converting tables to lists and records..
Many thanks for looking.
Solved! Go to Solution.
Hi,
Use Table.Group with Text.Combine
= Table.Group(PrevStep, {"ID"}, {{"Values", each Text.Combine([Values],","), type text}})
Stéphane
Many thanks Stéphane!
That is really much appreciated - that saved the day 😊
Many thanks Stéphane!
That is really much appreciated - that saved the day 😊
Hi,
Use Table.Group with Text.Combine
= Table.Group(PrevStep, {"ID"}, {{"Values", each Text.Combine([Values],","), type text}})
Stéphane
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.