Forum Discussion

erhang's avatar
erhang
Helper II
8 years ago

Changing Column names

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 

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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