Unpivot ANY nested table and load to Power BI Desktop

This post moved here.

Comments

• Anonymous
  October 18, 2015
  Nice! thanks for sharing this.
• Anonymous
  October 19, 2015
  Hi Thanks for the comments
  
  I have a Excel Master data that has columns as below how do you do a transform so I can PLot data by Month in a Graph
  
  Activity| Jan Plan |Jan LBE|Jan New$|Feb Plan | Feb LBE
  Meeting | 10K| 12K|2K|45K|34K|65K
  
  
  
• Anonymous
  October 19, 2015
  Hi Bala,
  You can apply Unpivot Other Columns on the first column. This will flatten all the other columns. In Attribute column you have: Jan Plan, Jan LBR, ..., In Value you have the numbers. You can now split the Attribute column by space as a separator, and rename Attribute.1 to Month, and Attribute.2 to Plan/LBE/NEW$. If my comment is not clear, please submit the question in TechNet Power Query forum, and I will provide a detailed answer.
• Anonymous
  October 28, 2015
  Thanks for sharing! Thumbs up.
• Anonymous
  November 15, 2015
  This is great stuff thanx for sharing! Keep them coming...