Dealing with Column name changing

[Ap674]

Hi everyone ! I have a big problem that is ruining my whole dashboard! I am pivoting some columns eg 201920 Q1, 201819 Q1 and then I create measures using these pivoted columns. Everytime I refresh the dasboard is breaking as the new column name is 201920 Q2 etc... Do you have something to suggest on how to deal with this problem?

[edhans]

You can refer to the columns by index number. For example, instead of 

= Table.RenameColumns(#"Changed Type",{{"month Arriving date", "test"}})

Which is normally what would happen if you clicked on column and renamed it, modfy it to use the following syntax:

= Table.RenameColumns(#"Changed Type", {{Table.ColumnNames(#"Changed Type"){2}, "test"}})

Basically instead of referring to the "month Arriving date" column by name, I am getting the name of the 3rd column (Power Query indexes by 0, so {2} is the 3rd column) and renaming it to "test"

[danextian]

 Hi @Ap674 ,

Please post a sample data (a link to google/one drive or dropbox).

[Mann]

Hi @Ap674 

You need to handle dynamic column names in Power query before you do Pivoting. See this video for doing that.

https://www.youtube.com/watch?v=yBJr0sAc-m4

Mann.