Forum Discussion
Transpose data
Hi Team,
I want to tranpose horizontal data in vertical form. Please find the input that i have.
Output that i require.
Hi, I have just simulated your data except the Project names. Here is the image of the result. (Please note that I have created a Conditional Column in the PQE to sort the months).
You can download the file on which I have worked here:
Unpivot and Transpose with SortColumn Sample.pbix
If this sample is found to be helpful, please accept it as a solution which could help others too. Your Kudo's are welcome.
Best,
C.S.N. Raja
7 Replies
pls see my video
Thank you very much both of you ... both solution works very wells 🙂
Hi, I have just simulated your data except the Project names. Here is the image of the result. (Please note that I have created a Conditional Column in the PQE to sort the months).
You can download the file on which I have worked here:
Unpivot and Transpose with SortColumn Sample.pbix
If this sample is found to be helpful, please accept it as a solution which could help others too. Your Kudo's are welcome.
Best,
C.S.N. Raja
would you please share the sample data here
Hi, I had provided the link in my reply. Hope you are able to download the PBIX file. Please check and confirm.
