Power Query
Search…
published
Table
Table.RowCount

Table.RowCount

Returns the number of rows in the table.
function (table as table) as number

Description

Returns the number of rows in the table.

Category

Table.Information

Examples

Find the number of rows in the table.
Table.RowCount(Table.FromRecords({[CustomerID =1, Name ="Bob", Phone = "123-4567"],[CustomerID =2, Name ="Jim", Phone = "987-6543"],[CustomerID =3, Name ="Paul", Phone = "543-7890"]}))
3
Copy link
On this page
Table.RowCount
Description
Category
Examples