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.
Hi Team,
I have a data with the following structure.
I unpivoted the columns as follows,
then I split the Attribute column by number of characters
Next I did pivoting the Attribute 1 column with Value column which gave me the following table.
The expected table should only contain 2 rows. Can anyone please explain what did go wrong ?
Thanks,
Jos
Solved! Go to Solution.
Hi, @Jos13
Can you show me the result you want?
If this is the expected result your want ,you can check if the following sample file helps.
Best Regards,
Community Support Team _ Eason
Hi, @Jos13
Can you show me the result you want?
If this is the expected result your want ,you can check if the following sample file helps.
Best Regards,
Community Support Team _ Eason
@Jos13 , your post is not complete.
for unpivot refer
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |