Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have the following XLSX. (Example file link)
In this file you see a sheet called blogliste_gmc - that's the data.sheet that should be unipivot.
And three solution sheets (how to transform it)
Can someone help me?
Many Thanks
It looks like you have two sets of data.
If we treat it as two data sets we can pull them in separately, transform them and join them together.
Data1 is just unpivoting all columns except the first 3
Data 2, we
Once this is done you can join the two table together on the Attribute column (the one that is in both data sets aka row 4) and pivot / filter it however you like.
I have created a PBIX file pointing at your xlsx file for you to look at. https://www.dropbox.com/s/2643sop0a4lp2iz/merkmale_erstellen_automatisch_forum.pbix?dl=0
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |