Power Query
Search…
published
Powered By GitBook
Table.ColumnCount

Table.ColumnCount

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

Description

Returns the number of columns in the table table.

Category

Table.Information

Examples

Find the number of columns in the table.
1
Table.ColumnCount(Table.FromRecords({[CustomerID =1, Name ="Bob", Phone = "123-4567"],[CustomerID =2, Name ="Jim", Phone = "987-6543"],[CustomerID =3, Name ="Paul", Phone = "543-7890"]}))
Copied!
3
Last modified 3yr ago