Table.PrefixColumns Function in Power Query
The Table.PrefixColumns function returns a table where all the columns names from the table provided are prefixed with the given text, prefix, plus a period in the form prefix .ColumnName.
Syntax
Table.PrefixColumns(table as table, prefix as text) as table
Example: Prefix the columns with "mytext" in the table.
Initially we have the table with the column names as shown in the image below:
Power Query M
= Table.PrefixColumns( #"Changed Type", "mytext" )
The above formula added the given prefix, mytext with a period with the column name, and returns the table as shown in the image below.
