List.Min
Returns the smallest value in a list.
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
list: the items to search. Nulls are ignored when the list has other values.default(optional): the value returned when the list is empty. Without it, an empty list gives null.
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
- An empty list returns null unless you give a default. A null then flows into the next calculation and can cause a surprise.
- The default changes the answer only when the list is empty, not when it has values.
- For the smallest rows of a table, use Table.Min, which returns a record.
- Text is compared alphabetically, so the "smallest" text may not be what you expect with numbers stored as text.
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.