Forum Discussion
Transpose data
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
Advocate IIHi, 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