Table.FirstValue

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

Returns the first column of the first row of the table table or a specified default value.

Related functions

Other functions related to Table.FirstValue are:

• Table.AggregateTableColumn
• Table.First
• Table.FirstN
• Table.Last
• Table.LastN
• Table.Max
• Table.MaxN
• Table.Min
• Table.MinN
• Table.SingleRow

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/table-firstvalue
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.