Reply
avatar user
Anonymous
Not applicable

Help - Transform Nested table

Hello all,

 

I'm quite new with Power BI and searching for help in convert a nested table.
The aim is to create a new table from the nested table records.
Collum-1 records should be the headers from the new table columns and the column-2 records should be the records to fulfill the new rows under the new columns.

Sample:

 

Converting the Nested Table bellow

pink_dutch_0-1642337470054.png

 

Into the new table like this

 

 

pink_dutch_2-1642337626490.png

 

What should I do it?

 

Pink.dutch

 

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

It looks to me like you can pivot the field.name column using Parameter Value as your values column.

View solution in original post

2 REPLIES 2
avatar user
Anonymous
Not applicable

Thanks @AlexisOlson it works. just having another challenge in regards multi-language, managing.

 

AlexisOlson
Super User
Super User

It looks to me like you can pivot the field.name column using Parameter Value as your values column.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)