Table.ReorderColumns is a Power Query M function that reorders columns in a table according to a specified column order. The function returns a new table with the columns reordered, handling missing columns based on an optional parameter.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Table.ReorderColumns(
table as table,
columnOrder as list,
optional missingField as nullable number,
) as tableDescription
Returns a table from the input table, with the columns in the order specified by columnOrder. Columns that are not specified in the list will not be reordered.
If the column doesn’t exist, an exception is thrown unless the optional parameter missingField specifies an alternative (eg. MissingField.UseNull or MissingField.Ignore).
Examples
Switch the order of the columns [Phone] and [Name] in the table.
// Output: Table.FromRecords( {[CustomerID = 1, Name = "Bob", Phone = "123-4567"]} )
Table.ReorderColumns(
Table.FromRecords( {[CustomerID = 1, Phone = "123-4567", Name = "Bob"]} ),
{"Name", "Phone"}
)Switch the order of the columns [Phone] and [Address] or use “MissingField.Ignore” in the table. It doesn’t change the table because column [Address] doesn’t exist.
// Output: Table.FromRecords( {[CustomerID = 1, Name = "Bob", Phone = "123-4567"]} )
Table.ReorderColumns(
Table.FromRecords( {[CustomerID = 1, Name = "Bob", Phone = "123-4567"]} ),
{"Phone", "Address"},
MissingField.Ignore
)Related functions
Other functions related to Table.ReorderColumns are:
