← Back to Table functions

Table.ColumnCount

This function will retrieve the total count of columns present in the specified table.

Syntax

Table.ColumnCount(table as table) as number

About

This function will retrieve the total count of columns present in the specified table.

Explanation

Determine the quantity of columns in the table by using Power Query M function MTable.ColumnCount() with the Table.FromRecords() method containing the data records. The output will indicate the total number of columns in the table, which in this case is 3.