Forum Discussion
Rename dynamic column header when transforming data
I am trying to incorporate data in a column into my report. However the field name is "Current Week Updates (3 Jun - 7 Jun)", with the dates component manually updated on a weekly basis in the source...
amitchandak
Super User
Super UserAnonymous , Syntax in is not correct for rename columns
https://learn.microsoft.com/en-us/powerquery-m/table-renamecolumns
example
Table.RenameColumns(
Table.FromRecords({[CustomerNum = 1, Name = "Bob", PhoneNum = "123-4567"]}),
{
{"CustomerNum", "CustomerID"},
{"PhoneNum", "Phone"}
}
)