Table.FirstValue

Updated on

Table.FirstValue is a Power Query M function that returns the first column of the first row of a table or a specified default value. The function returns a single value.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Table.FirstValue(
   table as table,
   optional default as any,
) as any

Description

Table.FirstValue fetches the first column of the first row from the table table, or a predetermined default value if specified.

Other functions related to Table.FirstValue are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/table-firstvalue