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'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!
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |