Forum Discussion
campelliann
Post Patron
Post PatronPivoting "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...
You can try removing the column before the pivot. Technically you are unpivoting by the way.
Rows to Column = Unpivot
Column to Rows = Pivot
nvprasad
Solution Sage
Solution SageHi Campelliann,
The transofmation looks correct only. There is no data for revenue with the combination of Projecto A & Subprojecto B. Hence it is showing null.
You can replace null with 0 for last 3 columns ( after transformation).
Thank You,
Regads,
Venkat Nalla
campelliannPost Patron
Post Patron
ajbogleHelper I
You can try removing the column before the pivot. Technically you are unpivoting by the way.
Rows to Column = Unpivot
Column to Rows = Pivot