Rename dynamic column header when transforming data

[Anonymous]

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 data file (excel web).

Trying to find a way to prevent an error with the data every week when the field name is updated. Thought of adding a step to rename the column header automatically to a standardized name so that there won't be an error when I am pulling the data in the report. Is there a way to do this?

Right now this is what I have:

Of course, there is an error and I am stuck. Please provide suggestions for a solution based on your expertise.

Thanks in advance!

[amitchandak]

@Anonymous , 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"}
}
)