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.
Dear all,
How can I combine multiple rows into single row with multiple columns as below?
Regards,
Urmas
Solved! Go to Solution.
You can first Group By Id, making sure you select "All Rows" as the Aggregation. Name the column "NewRows". Then you can do this:
= Table.TransformColumns(#"Grouped By", {{"NewRows", each Table.FromRows(List.Combine(Table.ToRows(_)))}})
Then delete the other columns and expand the tables.
--Nate
You can first Group By Id, making sure you select "All Rows" as the Aggregation. Name the column "NewRows". Then you can do this:
= Table.TransformColumns(#"Grouped By", {{"NewRows", each Table.FromRows(List.Combine(Table.ToRows(_)))}})
Then delete the other columns and expand the tables.
--Nate
In the solution, where do you type this:
= Table.TransformColumns(#"Grouped By", {{"NewRows", each Table.FromRows(List.Combine(Table.ToRows(_)))}})
I'm very new to Power BI, so appreciate the help!
IT works. perfectly. I only had to add curly brackets in one place in the end:
= Table.TransformColumns(#"Grouped Rows", {{"NewRows", each Table.FromRows({List.Combine(Table.ToRows(_))})}})
Thank you very much,
Urmas
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.