Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
RobHaigh
New Member

How to combine multiple rows in to columns

Trying to get my head round Dynamics 365 Finance and Operations and Power BI.
Finance and Operations holds product data and each product can have multiple attributes against it.
Due to the way Finance and Operations stores the data it looks initially like this.

ProductCodeAttributeNameTextValue
10000Size5
10000FinishMatt
10000HexABCDE
20000Size2
20000FinishGloss
20000HexDEFGH
30000SizeRoll
30000Length6
30000MatchFull
30000WashableYes


For ease of reporting in Power BI I would like to transform it to look like this.

ProductCodeSizeFinishHexLengthMatchWashable
100005MattABCDE   
200002GlossDEFGH   
30000Roll  6FullYes

I am a bit stuck / end of my knowledge / patience   🙂

Cant get it to work.....

Anyone got any ideas?

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi @RobHaigh ,

 

In Power Query, select your [AttributeName] column, go to the Transform tab > Pivot Column and set up the dialog like this:

BA_Pete_0-1715082539130.png

 

...to get this output:

BA_Pete_1-1715082583426.png

 

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

2 REPLIES 2
RobHaigh
New Member

Pete, Many thanks, saved me a ton of head scratching 🙂

BA_Pete
Super User
Super User

Hi @RobHaigh ,

 

In Power Query, select your [AttributeName] column, go to the Transform tab > Pivot Column and set up the dialog like this:

BA_Pete_0-1715082539130.png

 

...to get this output:

BA_Pete_1-1715082583426.png

 

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors