• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Query - adding new column, can't refresh without missing column 1 error


New Member
Hey there! So fairly new to Power Query in Excel, but have been able to use it for my reporting purposes.

I have a set of data showing our customers sales data by Volume. Each column is a month. I'm trying to drop in the most recent month of November. When I go to refresh, I'm getting the 'Expression Error, Column is missing, column 1"

Any help would be greatly appreciated. Thank you!

Adding Month of November

Shows in my Source in the query

End part of query I had to update to show that month and 'type number'

Showing Error. Date columns start from 1/1/21 to date.


  • 1671131156371.png
    12.5 KB · Views: 2
Do you have a Column 1 in your data? If not, you need to remove it from the UnpivotOtherColumns step or supply the correct column name.