← Back to Table functions

Table.RowCount

The function retrieves the total count of rows present in the specified table.

Syntax

Table.RowCount(table as table) as number

About

The function retrieves the total count of rows present in the specified table.

Explanation

Determine the row count of the table using Power Query function MTable.RowCount(Table.FromRecords({ [CustomerID = 1, Name = "Bob", Phone = "123-4567"], [CustomerID = 2, Name = "Jim", Phone = "987-6543"], [CustomerID = 3, Name = "Paul", Phone = "543-7890"] })) The output will be 3.