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

[Marshallpb1]

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.

 

[Debaser]

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.

 

[Marshallpb1]

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.

Appreciate the help, that seemed to work!