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.
You might consider just pulling in 12 months of data every time and filtering it out correctly in Power BI.
Proud to be a Datanaut!
I think you can unpivot columns to convert column to list, I think unpivoted table can simply to calculate in dax formula.
Current power bi not contains features which you wanted.