Forum Discussion
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_DecklerCommunity Champion
You might consider just pulling in 12 months of data every time and filtering it out correctly in Power BI.
- AnonymousNot 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