Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.