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.
I currently have a data source like follows:
SKU | Site 1 | Site 2 | Site 3 | Week |
123 | 10 | 9 | 7 | 1 |
123 | 9 | 9 | 7 | 2 |
789 | 1 | 2 | 1 | 1 |
789 | 2 | 2 | 2 | 2 |
To create part of my report I figured it would be easiest if I could create a second data source from the original that is layed out differently, but I can't quite figure out if it is possible.
The end result would be:
SKU | Week | Site | Price |
123 | 1 | Site 1 | 10 |
123 | 1 | Site 2 | 9 |
123 | 1 | Site 3 | 7 |
123 | 2 | Site 1 | 9 |
123 | 2 | Site 2 | 9 |
123 | 2 | Site 3 | 7 |
789 | 1 | Site 1 | 1 |
789 | 1 | Site 2 | 2 |
789 | 1 | Site 3 | 1 |
789 | 2 | Site 1 | 2 |
789 | 2 | Site 2 | 2 |
789 | 2 | Site 3 | 2 |
Any Ideas?
Solved! Go to Solution.
@JACK__ ,
Go to Power Query Editor and select all the 3 site columns of the table you wanted to modify. Then, select unpivot columns (highlighted in the image),
your resulted table should be like this, and then you can rename the value column as price,
@JACK__ ,
Go to Power Query Editor and select all the 3 site columns of the table you wanted to modify. Then, select unpivot columns (highlighted in the image),
your resulted table should be like this, and then you can rename the value column as price,
Thank You 🙏
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |