LECFrequent Visitor9 years agoSolvedPivoting 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 th...Show MoreSean9 years agoLECIn the Query Editor...1) Unpivot Sales & Inventory2) Merge Year and Atrribute3) Pivot the Merged Column (Don't Aggregate)As shown here...Hope this helps! :smileyhappy:
Sean9 years agoLECIn the Query Editor...1) Unpivot Sales & Inventory2) Merge Year and Atrribute3) Pivot the Merged Column (Don't Aggregate)As shown here...Hope this helps! :smileyhappy:
Sean9 years agoLECIn the Query Editor...1) Unpivot Sales & Inventory2) Merge Year and Atrribute3) Pivot the Merged Column (Don't Aggregate)As shown here...Hope this helps! :smileyhappy:
SeanCommunity Champion9 years agoLECIn the Query Editor...1) Unpivot Sales & Inventory2) Merge Year and Atrribute3) Pivot the Merged Column (Don't Aggregate)As shown here...Hope this helps! :smileyhappy:
