Forum Discussion
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 timestamp.
I've been looking for the different examples for multiple rows combination but no luck. Thanks!
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
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.
4 Replies
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
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.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.
