Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have current table as below; how can I transform to get the result table;
Thank you!
Qayyum Halid
Go to Power Query Editor
1. Select Q1 & Q2 column, Right click and choose Unpivot column
2. Repeat the same step above by selecting the Whats your name and Age Column
You will be left with the way you want your table to look like but with duplicate rows.
Go to HOME tab under remove rows select remove duplicate rows. Thats it !
This Tutorial will provide you more details if required.
Pivot/Unpivot PowerBI Feature explained | Power Query | MiTutorials - YouTube
Regards
Ismail
It become like this;
Then, if i remove Attribute duplicate; it become as below;
If i remove duplicate in Attribute.1, it become as below
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.