Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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/
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |