Downloads
Power Query MList: summarizeBeginner

List.Min

Returns the smallest value in a list.

Syntax
List.Min(list, optional default)

Returns: The smallest item, or the default value when the list is empty.

What it does

List.Min finds the smallest item in a list. For numbers it is the lowest figure; for dates it is the earliest date; for text it is the first value in alphabetical order. Use it to find the lowest price paid, the earliest unpaid invoice date or the earliest transaction in a period.

Syntax and arguments

Example

A purchasing team wants the lowest unit price a vendor charged this quarter, and the date of the earliest bill still open.

let
    UnitPrices = {14.20, 13.75, 15.10, 13.75},
    LowestPrice = List.Min(UnitPrices, 0),
    OpenBillDates = {#date(2026, 7, 3), #date(2026, 6, 28), #date(2026, 8, 1)},
    EarliestOpen = List.Min(OpenBillDates)
in
    EarliestOpen

EarliestOpen is June 28, 2026. The default of 0 is used for LowestPrice, so an empty list gives zero instead of null, which matters if the result feeds a division.

Example: a second, different use

Finding the earliest transaction date in a month: pass a list of dates from a table column and read the result as the start of the period.

Things to watch

In business terms

Lowest price paid, earliest open item for aging, earliest and latest transaction dates for a period check and minimum balance tests are common uses. Pair it with List.Max to show the range of values.

Related functions

All Power Query M functions · View as Markdown · M basics