Power bi Rename Coulmns
02-21-2022
One of the most useful formulas I use in power query for power bi is renaming columns when the name of the column can change in the source file. I usaly use it before
The formula is
= Table.RenameColumns( #table, { {Table.ColumnNames(#table){number of column}, "New name"} } )
example
= Table.RenameColumns( #"Removed Other Columns2, { {Table.ColumnNames(#"Removed Other Columns2"){0}, "Source"} } )
The next 2 formulas are table rename columns and table columns name.
The first one is for renaming the column but it needs the the column name
the second one is to call the column by column number starting at 0
Table.RenameColumns(table as table, renames as list, optional missingField as nullable number)
https://docs.microsoft.com/en-us/powerquery-m/table-renamecolumns
Table.ColumnNames(table as table) as list