Forum Discussion
TSweeney15
3 years agoNew Member
Unpivot Columns Not Picking up Data
I have three columns and numerical values in each one (picture included). When I load the table into PQ, all my values are calculating correctly. However, when I Unpivot columns, January and February are picking up the correct data except March seems to come up short each time. I am changing the type to "whole number" before unpivoting but not sure if that affects it greatly. Any idea what's happening?