OpenBI Docs Buy

Record.FieldCount

How many fields a record has.

Group: Record. Power Query M has it too: a query that uses it is written as in Power BI.

Syntax

Record.FieldCount(record as record) as number
ParameterTypeDescription
recordrecordThe record to work on.

Returns

number. The count; 0 for the empty record [].

Examples

An order's fields

Record.FieldCount([Order = 1001, Shop = "Oslo", Total = 120])
3

The empty record

Record.FieldCount([])
0

Record.FieldNames, Table.ColumnCount.

Last updated · OpenBI Studio 0.3.79