Forum Discussion

TSweeney15's avatar
TSweeney15
New Member
3 years ago

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? 

2 Replies

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion

    Show us the data after the Pivot please so that we can investigate

    And you can post the Advanced Editor code too please.

  • Hi,

    please make an example of what you intend for "come up short". Post the result you get by unpivoting the data you have posted.