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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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