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
would you please share the sample data here
Advocate IIHi, I had provided the link in my reply. Hope you are able to download the PBIX file. Please check and confirm.
can download power bi file. need to see actual raw data that you have created. so i can manage my accordingly. thanks for your help
- RajaCSN
As I said, I have just simulated your sample data in an Excel sheet. Here is the image of my excel table:
If the suggestions provided by me are useful, please consider "Accept" as a solution.
Best,
C.S.N. Raja