Forum Discussion

stu_adz's avatar
stu_adz
Frequent Visitor
2 years ago
Solved

Summarize and transpose into new table using column headers as row labels

Hi there,   I have looked at similiar posts but the solutions presented did not seem to work for me. I am very new to PowerBI and I have the following sampe data set:   I am trying to achi...
Need Help
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, stu_adz 

     

    You can try the following methods. Select the first two columns-Unpivot Other columns:

    Result:

    Using the matrix view:

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

mh2587's avatar
mh2587
Icon for Super User rankSuper User
2 years ago

You can unpivot this from Power Query.

stu_adz's avatar
stu_adz
Frequent Visitor
2 years ago

Hi, thanks for your reply.

 

When I apply this to my data, I get an error message that says:

 

Column 'Period 1 Value' in table '23_24' cannot be found or may not be used in this expression. Column 'Nominal' in Table '23_24' contains a duplicate value '0001-0001' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

 

This is because I have other table that are linked to the one I am unpivoting.  Is there another way around this?

 

Thanks