Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm sure this has been asked, but I'm still struggling to make the data pivot in the way that I want it to.
I have a query connected to Power BI with data pulling back by week since 2016, like the following:
Year Week Sales Inventory
2016 1 100 200
2016 2 104 208
....
2017 1 132 294
2017 2 88 105
........
I'd like to be able to pivot the table to line up like this:
Week 2016 Sales 2017 Sales 2016 Inventory 2017 Inventory
1 100 132 200 294
2 104 88 208 105
Anyone have advice?
Solved! Go to Solution.
In the Query Editor...
1) Unpivot Sales & Inventory
2) Merge Year and Atrribute
3) Pivot the Merged Column (Don't Aggregate)
As shown here...
Hope this helps!
In the Query Editor...
1) Unpivot Sales & Inventory
2) Merge Year and Atrribute
3) Pivot the Merged Column (Don't Aggregate)
As shown here...
Hope this helps!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |