MINA
The smallest value in a column, text counting as 0, TRUE as 1 and FALSE as 0.
Group: Aggregation. Compatible with DAX.
Syntax
MINA ( <column> )| Parameter | Type | Description |
|---|---|---|
column | Column | The column whose smallest value is wanted; it may hold numbers, text or logical values. |
Returns
Number. The smallest value, where text counts as 0, TRUE as 1 and FALSE as 0.
Remarks
- Blank cells are left out.
- On a column of numbers it gives the same answer as
MIN; on a column of text, 0.
Examples
Numbers and text
EVALUATE
ROW (
"Lowest price", MINA ( Holdings[Price] ),
"Of the names", MINA ( Products[Product] )
)| Lowest price | Of the names |
|---|---|
| 92.15 | 0 |