Forum Discussion
Transpose a column with month name to Rows
Hi!
I have the below query that i want to transpose, but when I try, it does not convert the months into rows.
Before
after
can you guys assist?
Make sure you have ALL the Month Columns selected / highlighted Before clicking 'Unpivot Columns'. This will then give you Cat & SubCat as columns, with 'Attribute' as the Months and 'Value' as the cooresponding Values.
P.S. Unless you specificlly want it, I would delete the Total Column before Unpivot'ing. You can add this up later easier than maintaing the Total Row...
FOrrest
3 Replies
Make sure you have ALL the Month Columns selected / highlighted Before clicking 'Unpivot Columns'. This will then give you Cat & SubCat as columns, with 'Attribute' as the Months and 'Value' as the cooresponding Values.
P.S. Unless you specificlly want it, I would delete the Total Column before Unpivot'ing. You can add this up later easier than maintaing the Total Row...
FOrrest
Screenshot or Query is missing. Please share
Thanks
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
