Downloads
DAXAggregationBeginner

MIN

Returns the smallest value in a column, or the smaller of two values.

Syntax
MIN(<column>) or MIN(<expression1>, <expression2>)

Returns: A value of the same type as the input (a scalar). BLANK when the column has no values in the current filter context.

What it does

MIN finds the lowest value in one column that is still visible after the filters are applied. It also has a second form that compares two values side by side and returns the smaller one, which is useful for capping a figure. Use it for the lowest price paid, the earliest posting date or the smallest invoice in a period.

Syntax and arguments

Example

The procurement lead wants the lowest unit cost paid for each product this year, to see where prices have dropped.

Lowest Unit Cost = MIN(Product[UnitCost])

With the year slicer set, the measure looks only at products visible in that year. Placed on a matrix with product names on the rows, each product shows its own minimum.

Example: a second, different use

Cap a line's recognized amount at an approved limit, using a calculated column:

Capped Amount = MIN(Sales[SalesAmount], 5000)

Each line shows its own sales amount unless it exceeds 5,000, in which case it shows 5,000. This is a row level calculation, so it belongs in a calculated column, not a measure.

Things to watch

In business terms

MIN is used for the earliest invoice date in an aging report, the lowest margin in a product group, the lowest bid received, and any cap or floor applied to a balance, such as a credit limit or a minimum fee.

Related functions

All DAX functions · View as Markdown · DAX fundamentals