The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
It looks to me like you can pivot the field.name column using Parameter Value as your values column.
Thanks @AlexisOlson it works. just having another challenge in regards multi-language, managing.
It looks to me like you can pivot the field.name column using Parameter Value as your values column.