Forum Discussion

Aldimar_Junior's avatar
Aldimar_Junior
Frequent Visitor
3 years ago
Solved

Melt Rows in a table

Hi everyone, I'm pretty new to powerBI and DAX.. and I'm having some trouble trying to "melt" a table:   I have the following table user.id user.fieldCode user.fieldRule user.fieldValue 1...
Need Help
  • rsbin's avatar
    rsbin
    3 years ago

    Aldimar_Junior ,

    Assumed you tried to "Pivot Column" in Power Query. 

    This will work but first remove the user.fieldRule column

    Then Pivot on the fieldCode column

    This is what I get, which I believe is what you are looking for.

    Hope you can get this to work for you.

    Regards,

rsbin's avatar
rsbin
Community Champion
3 years ago

Aldimar_Junior ,

Assumed you tried to "Pivot Column" in Power Query. 

This will work but first remove the user.fieldRule column

Then Pivot on the fieldCode column

This is what I get, which I believe is what you are looking for.

Hope you can get this to work for you.

Regards,

Aldimar_Junior's avatar
Aldimar_Junior
Frequent Visitor
3 years ago

I dont think this would work in my case, because my values are in different columns, not in only one like yours