Forum Discussion

umairarshad's avatar
umairarshad
Helper II
1 year ago
Solved

Column to row conversion

Hello all, I have a data set as below.     and i want the to covert it like following    i.e. date should be in columns and each GSE must have the correct consumption.   Pleae adv...
Need Help
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    Hi umairarshad 
    Thanks for reaching out to the Microsoft fabric community forum.
    As mentioned by jennratten   you can use matrix to get your desired visual consisting of dates as columns but if you are trying to transform the underlying data itself use pivot column.
    For the sample data I took, Pivoting the date column over Quantity column worked as per your requirement

     

     

     



    Did I answer your question? Mark my post as a solution, this will help others!

    If my response(s) assisted you in any way, don't forget to give "Kudos"

    Thanks and Regards

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi umairarshad 
Thanks for reaching out to the Microsoft fabric community forum.
As mentioned by jennratten   you can use matrix to get your desired visual consisting of dates as columns but if you are trying to transform the underlying data itself use pivot column.
For the sample data I took, Pivoting the date column over Quantity column worked as per your requirement

 

 

 



Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to give "Kudos"

Thanks and Regards

  • umairarshad's avatar
    umairarshad
    Helper II
    1 year ago

    Thank you. It worked.