Forum Discussion

gmiro's avatar
gmiro
Regular Visitor
5 years ago
Solved

Multiple rows with different atributes into multiple columns

Hi all, I have a data stream with multiple rows with different parameters for the same timestamp:   I'd like to transform it into a unique table with columns as parameters for the same times...
Need Help
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, gmiro 

    Please try the below in Power Query Editor.

     

    - select Parameter Column

    - click Pivot Column

    - select Value as Value-Column

    - Click

     

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

    OK

     

     

  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, gmiro 

    Thank you for your feedback.

    It worked fine on my Power Query Editor.

    If it is OK with you, please share your sample pbix file, then I can try to look into it.

     

    Thank you.

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, gmiro 

Please try the below in Power Query Editor.

 

- select Parameter Column

- click Pivot Column

- select Value as Value-Column

- Click

 

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

OK

 

 

  • gmiro's avatar
    gmiro
    Regular Visitor
    5 years ago

    Hi Mr Kim Jihwan_Kim 

    It gives me an error: DataFormat.Error: The input provided as a DateTime value could not be parsed. Details: 20.

    I've also tested with datetime as a text with no luck.

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      5 years ago

      Hi, gmiro 

      Thank you for your feedback.

      It worked fine on my Power Query Editor.

      If it is OK with you, please share your sample pbix file, then I can try to look into it.

       

      Thank you.

       

      Hi, My name is Jihwan Kim.

      If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

      • gmiro's avatar
        gmiro
        Regular Visitor
        5 years ago

        Hi Mr Kim Jihwan_Kim 

         

        I've started from scratch and it worked thanks!