Forum Discussion

Narendra90's avatar
Narendra90
Frequent Visitor
3 years ago
Solved

Transpose data

  Hi Team, I want to tranpose horizontal data in vertical form. Please find the input that i have. Output that i require.  
Need Help
  • RajaCSN's avatar
    RajaCSN
    3 years ago

    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