Share via


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...