<!-- https://learnsql.cpetoday.com/functions/m/list-min -->
# List.Min

Language: Power Query M
Category: List: summarize
Syntax: List.Min(list, optional default)
Summary: Returns the smallest value in a list.
Returns: The smallest item, or the default value when the list is empty.
Level: Beginner
Related: List.Max, List.Average, List.Sort, List.Sum, List.RemoveNulls

## 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.

```powerquery
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.
