Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Put modality in column

Hello,

I have a dataset like this :

They have a several Captor in "Captor type" column and I want to transpose this dataset like this :

DateTemp_Capt_109Humidity_Capt_109Temp_Capt_110Humidity_Capt_119
06/06/2023 15:15:0020471255
06/06/2023 15:16:002047.51255



I have already tried to pivot column "Captor type" but it doesnt spread value correctly all value are concentrate in Capt_109 columns :

 

Someone can help me please.

 

Need Help

1 Reply

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    Hi Anonymous ,

     

    This looks like an XY Problem.

    What are you actually trying to achieve by doing this? You're moving the data structure away from the most efficient and usable format for Power BI reporting.

     

    Pete