Forum Discussion

campelliann's avatar
campelliann
Icon for Post Patron rankPost Patron
4 years ago
Solved

Pivoting "not working" in PowerQuery

So basically I am Pivoting a column called "budget type". That then transforms into "Margem" "Revenue" Custo (3 last columns). The issue is that this only works if Projecto and subproject  Rows ar...
  • ajbogle's avatar
    ajbogle
    4 years ago

    You can try removing the column before the pivot. Technically you are unpivoting by the way.

     

    Rows to Column = Unpivot

    Column to Rows = Pivot