Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 🙏
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |