DAX Aggregation - MINA function

Description

Returns the smallest value in a column, including any logical values and numbers represented as text.

Syntax

MINA (<column>)

Parameters

Return Value

Returns a decimal number.

Remarks

The following types of values in the column are considered −

• Numbers
• Dates
• Text that can be converted to numeric values
• Logical values, such as TRUE and FALSE are treated as 1 if TRUE and 0 (zero) if FALSE.

Empty cells are ignored. If the column contains no numeric values, MINA returns 0 (zero).

Example

= MINA (ProductInventory[InventoryDate])