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
| Argument | Description |
|---|---|
| table | The Table to modify. |
| newColumnName | The name of the new column. |
| optional initialValue | The initial column index. The default initial index is 0. |
| optional increment | The 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")
| CustomerID | Name | Phone | Index |
|---|---|---|---|
| 1 | Bob | 123-4567 | 0 |
| 2 | Jim | 987-6543 | 1 |
| 3 | Paul | 543-7890 | 2 |
| 4 | Ringo | 232-1550 | 3 |
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)
| CustomerID | Name | Phone | Index |
|---|---|---|---|
| 1 | Bob | 123-4567 | 1 |
| 2 | Jim | 987-6543 | 3 |
| 3 | Paul | 543-7890 | 5 |
| 4 | Ringo | 232-1550 | 7 |
Show: