Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @Ap674 ,
Please post a sample data (a link to google/one drive or dropbox).
Proud to be a Super User!
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.