Table.AddIndexColumn

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

Returns a table with a new column with a specific name that, for each row, contains an index of the row in the table.

Table.AddIndexColumn(table as table, newColumnName as text, optional initialValue as nullable number, optional increment as nullable number) as table  

ArgumentDescription
tableThe Table to modify.
newColumnNameThe name of the new column.
optional initialValueThe initial column index. The default initial index is 0.
optional incrementThe column index increment. The default increment is 1.
Table.AddIndexColumn(Table.FromRecords(  
  
{  
  
      [CustomerID = 1, Name = "Bob", Phone = "123-4567"],  
  
      [CustomerID = 2, Name = "Jim", Phone = "987-6543"] ,  
  
      [CustomerID = 3, Name = "Paul", Phone = "543-7890"] ,  
  
      [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]  
  
}  
  
), "Index")  

CustomerIDNamePhoneIndex
1Bob123-45670
2Jim987-65431
3Paul543-78902
4Ringo232-15503
Table.AddIndexColumn(Table.FromRecords(  
  
{  
  
      [CustomerID = 1, Name = "Bob", Phone = "123-4567"],  
  
      [CustomerID = 2, Name = "Jim", Phone = "987-6543"] ,  
  
      [CustomerID = 3, Name = "Paul", Phone = "543-7890"] ,  
  
      [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]  
  
}  
  
), "Index", 1, 2)  

CustomerIDNamePhoneIndex
1Bob123-45671
2Jim987-65433
3Paul543-78905
4Ringo232-15507
Show: