Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

M Language - unpivot issue

Hi I am trying to Unpivot a General Ledger Table in Power Query   The original format is   CC ACC P1 Actual P2 Actual P1 Budget P2 Budget 40 40120 4221.985 9936.52 6511.099 8413.8...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Thanks Matt

     

    It worked

     

    Regards

     

    Pedro

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
9 years ago

On a hunch, try adding an index column as the very first step.  When you repivot data, you need a unique row identifier, so if you add that first, you can then use it when you put it back together again. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thanks Matt

     

    It worked

     

    Regards

     

    Pedro

    • MattAllington's avatar
      MattAllington
      Icon for Community Champion rankCommunity Champion
      9 years ago

      great :-)  If you want to learn more about Power Query, you may be interested in my online training course  http://xbi.com.au/pqt 

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Thanks, Matt.

         

        I found on google.  

         

        The link above is not working for me.

         

        Regards

         

        Pedro