Table.Min

Table.Min is a Power Query M function that identifies the smallest row in a table based on comparison criteria. The function returns the smallest row, or an optional default value if the table is empty.

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

Syntax

Table.Min(
   table as table,
   comparisonCriteria as any,
   optional default as any,
) as any

Description

Returns the smallest row in the table, given the comparisonCriteria. If the table is empty, the optional default value is returned.

Examples

Find the row with the smallest value in column [a] in the table.

// Output: [a = 2, b = 4]
Table.Min( 
    Table.FromRecords( {
        [a = 2, b = 4],
        [a = 6, b = 8]
    } ),
    "a"
 )

Find the row with the smallest value in column [a] in the table. Return -1 if empty.

// Output: -1
Table.Min( #table( {"a"}, {} ), "a", -1 )

Related functions

Other functions related to Table.Min are:

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

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