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, my data is in SAP and currently designed by rows and i can not change this, but i need to change some parts of it into columns.
Here is an example:
Present structure
ID | Stop | Date | Time |
P6544 | 2 | 01-01-2021 | 10:50 |
P6544 | 4 | 01-01-2021 | 11:55 |
P6544 | 4 | 02-01-2021 | 11:35 |
P6585 | 4 | 01-01-2021 | 09:45 |
Here is what i would like the structure to be changed into:
ID | Stop 1 | Date 1 | Time 1 | Stop 2 | Date 2 | Time 2 | Stop 3 | Date 3 |
P6544 | 2 | 01-01-2021 | 10:50 | 4 | 01-01-2021 | 11:55 | 4 | 02-01-2021 |
P6585 | 4 | 01-01-2021 | 09:45 |
So some tips regarding changing structure from column to row would be well recieved 🙂
And sorry about the messed up tables, i use the tabletool from PowerBI and it still gives me a html error...
Solved! Go to Solution.
@bilingual , first add an index column by ID -https://www.youtube.com/watch?v=7CqXdSEN2k4
then unpivot new index column and date
https://radacad.com/pivot-and-unpivot-with-power-bi
Hi @bilingual ,
Maybe you can refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @bilingual ,
Maybe you can refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@bilingual , first add an index column by ID -https://www.youtube.com/watch?v=7CqXdSEN2k4
then unpivot new index column and date
https://radacad.com/pivot-and-unpivot-with-power-bi
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |