Forum Discussion

New2PowerBI's avatar
New2PowerBI
Helper III
9 years ago
Solved

Difficulty in unpivoting Table

I would like to unpivot a table; but I can't seem to easily unpivot after following a couple of tutorials.  I suspect it has to do with the data as it is, I think I need to clean it up some more.  H...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    New2PowerBI

    1) Select Employee Name, Employee Number and Column 2 - Unpivot Other Columns

    2) Select Column 2 - Pivot Column - Values Column select Value - Don't Aggregate

    3) Rename Attribute Column (rearrange columns if you want)

    Hope this helps! :smileyhappy:

Sean's avatar
Sean
Community Champion
9 years ago

New2PowerBI

1) Select Employee Name, Employee Number and Column 2 - Unpivot Other Columns

2) Select Column 2 - Pivot Column - Values Column select Value - Don't Aggregate

3) Rename Attribute Column (rearrange columns if you want)

Hope this helps! :smileyhappy:

dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago
**bleep** it Sean! You outdid me again! Plus a video... you're just showing off

Wow the word D A M N gets bleeped out?!
  • New2PowerBI's avatar
    New2PowerBI
    Helper III
    9 years ago

    Wow!  Thank you!!!  I knew it had to be a two-step "something" but just couldn't figure it out.  I met with someone here at work yesterday for close to an hour and they couldn't figure it out.  :-(

     

    Amazing!  Thank you!!!  Loving the help and support in this community and looking forward to sharing with others!  :-)