Fix This error message in desktop whenever column names got changed

[Anonymous]

I have some columns called October2023, November2023 and so on till september2024. The first column will be always the current month, that is when ever we enter into next month the october column will go and the first column will be November2023 and the last column will be October2024. So i have placed this data in a table visual, Whenever the column names get changed the columns are being changed in the power query editor but the visual on the Desktop is showing an error called fix this. 

can anyone suggest me how to avoid this as my data column names will get changed every month.

[Anonymous]

Ya , but its a client project where we are predicting their sales manufacturing details and all for the next 3 years . so once this is done I need to keep everything in a table and handover this to then. They will use that for the next 3 years . This is the requirement.

If you can these all columns (11) are for only one month , in the same way i have for 36 months that is 3 years. So I need to add all 36*11=396 columns. Once the report is handovered they should be using it for next 3 years.

This is the issue here. I must keep everything in table and handover to then then this will be completed.

Thanks for your patience.

[lbendlin]

I would reject that assignment in its current form, and help the client refactor the requirements.

[Anonymous]

Yes, I tried like that but I hahve almost 200 columns . So i can't keep all this columns in a table when I use Unpivot option and also I can't keep all columns in matrix at a time as matrix supports only 100 columns. So can you please suggest me any other option.

Thanks in advance

[lbendlin]

No user will ever scroll through 200 columns. Use fewer columns.

[lbendlin]

Don't use these columns.  Unpivot your data in Power Query to make it usable, and independent of the data source's meta data changes.