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
    Community 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.