PQ Pivot Columns Causes data in two other columns to change to null

wookinpunub 1 Reputation point
2021-01-19T20:53:55.24+00:00

I have a simple Table for Power Query to transform. Headers with Supplier, Supplier Name, Item Type, Month, Budget-Forecast & Total Column. I am trying to Pivot Column Budget-Forecast into two new columns one for Budget and one for Forecast. When I Pivot Column I am selecting the Totals Column for the Values and I have tried both Don't Aggregate and Sum. However, Supplier Number and Supplier Name change to null but the other data is just fine. What am I doing wrong? I have googled this in great detail and cannot find a solution.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,160 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. wookinpunub 1 Reputation point
    2021-01-19T21:42:16.067+00:00

    I thought my data in the Supplier Number and Supplier Name columns all had values. Turns out not all of them did, which is what was causing the issue. I checked both Supplier Number and Name before and it did not show any blanks but now I am thinking my Table was filtered in other columns which caused me to not see the blanks.
    Chock this one down to Operator error.

    0 comments