Forum Discussion
Anonymous
9 years agoNot applicable
M Language - unpivot issue
Hi I am trying to Unpivot a General Ledger Table in Power Query The original format is CC ACC P1 Actual P2 Actual P1 Budget P2 Budget 40 40120 4221.985 9936.52 6511.099 8413.8...
- Anonymous9 years ago
Thanks Matt
It worked
Regards
Pedro
MattAllington
Community Champion
9 years agoOn a hunch, try adding an index column as the very first step. When you repivot data, you need a unique row identifier, so if you add that first, you can then use it when you put it back together again.
Anonymous
9 years agoNot applicable
Thanks Matt
It worked
Regards
Pedro