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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
toby
Regular Visitor

Expend to columns a column that in each of its cells is a table

Hello,

I've got in my table a column that in each of its cells is a table with 5 similar columns.. I want to expned this column, so that these 5 inner coulns join the main table columns, and the value in each cell is what was a row in the inner table. (i.e “flatten” the table in each cell so they are records, than expand the column).

 

I would apprecaite your help with that, thanks a lot!

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@toby,

 


I've got in my table a column that in each of its cells is a table with 5 similar columns.. I want to expned this column, so that these 5 inner coulns join the main table columns, and the value in each cell is what was a row in the inner table. (i.e “flatten” the table in each cell so they are records, than expand the column).

 


 

Could you share some sample data and clarify more details about your issue?

 

Regards,

Jimmy Tao

vanessafvg
Super User
Super User

@toby can you provide an example of your data and your expected result 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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