- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Into the new table like this
What should I do it?
Pink.dutch
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It looks to me like you can pivot the field.name column using Parameter Value as your values column.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks @AlexisOlson it works. just having another challenge in regards multi-language, managing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It looks to me like you can pivot the field.name column using Parameter Value as your values column.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-16-2024 09:11 AM | |||
Anonymous
| 08-28-2023 04:35 AM | ||
08-05-2024 11:10 AM | |||
05-08-2023 05:29 PM | |||
08-02-2024 09:00 AM |