Pivoting

Question

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.&nbsp;I have a query connected to Power BI with data pulling back by week since 2016, like the following:&nbsp;Year &nbsp; &nbsp; &nbsp; &nbsp; Week &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sales &nbsp; &nbsp; &nbsp; &nbsp;Inventory2016 &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100 &nbsp; &nbsp; &nbsp; &nbsp; 2002016 &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;104 &nbsp; &nbsp; &nbsp; &nbsp;208....2017 &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 132 &nbsp; &nbsp; &nbsp; &nbsp; 2942017 &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 88 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;105........&nbsp;I'd like to be able to pivot the table to line up like this:&nbsp;Week &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016 Sales &nbsp; &nbsp;2017 Sales &nbsp; 2016 Inventory &nbsp; 2017 Inventory1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 132 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2942 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;104 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;88 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;208 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;105&nbsp;Anyone have advice?

sean · Accepted Answer

LECIn the Query Editor...1) Unpivot Sales &amp; Inventory2) Merge Year and Atrribute3) Pivot the Merged Column (Don't Aggregate)As shown here...Hope this helps! :smileyhappy:

Forum Discussion

Pivoting

1 Reply

Related content

Pivot issue

Pivot / Unpivot?

Pivot(?) Help

Pivot\Unpivot

Table Pivot, result explanation