Power query can be so powerful and once again it came to my rescue.

I had a requirement where I wanted to append some text to the end of each of the column names in my table.

To do this I did the following below.

  • This is what the columns looked like before the change.
  • Next, I put in the following Power Query Syntax which then appends the text “(German)” to each column.
    #"Append to Column Names" = Table.TransformColumnNames(#"Added Custom7", (columnName as text) as text => columnName & " (German)")
  • Now when I view the column headers it has got the dates with the text appended as shown below.

This saved me a lot of time and manual effort.

I hope you found this helpful!

Thanks for reading, any comments or suggestions are most welcome.