Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Unpivot selected columns with values are not working and getting error on all the columns.

Hi Experts,

I am trying to do Unpivot selected columns from power query and it is not working and getting error on all the columns.

I want to make a header as a column and values as a other column to plan for some visual.

 

Before:

After selected all the above 3 columns and clicked "Transform -> Unpivot only selected columns"

 

All the other columns also getting error and don't know what's happening ..

Please help to achieve on this ..

 

Thanks

DK

2 Replies

  • Anonymous 

     

    Please provide the data you are using.  Hard to debug without it.

     

    Regards

     

    Phil

  • What is the error you get? (click in the preview table to the left of the word "Error")