Changing Column names

[erhang]

Hi Dear Power Team ;

İ need your help about below issue.

İ have a table in excel as below   :

İ created a dashboard with a matrix table on power bi and show that table on dashboard.

My problem is when the column names changed the table is not working.

İ am always looking for per 3 months on the table.

For example after i created that table this month  , next time i will check for the months : July,August,September  so in excel in A column will be July and then B column will be August and then C Column will be September.

So is there any way when i change the column name in excel in my dashboard the names will change automaticly too.Also in my table in power Bi too.

thanks for your kindly supports dear friends , i will wait for your infos.

Erhan 

[v-shex-msft]

Hi @erhang,

I think you can unpivot columns to convert column to list, I think unpivoted table can simply to calculate in dax formula.

Unpivot Data Using Excel Power Query

Current power bi not contains features which you wanted.

Regards,

Xiaoxin Sheng

[Greg_Deckler]

You might consider just pulling in 12 months of data every time and filtering it out correctly in Power BI.