Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |