The MINA function returns the smallest value in a column considering numbers, dates and logical values.
Syntax
MINA(
column
)
Parameters
- column: Name of the column from which you want to extract the lowest value.
Returned value
The MINA function returns a real number or a datetime value.
Additional Information
If you want to consider texts, you should use the MIN function.
Examples
We can obtain the minimum value of the freight cost contained in the Freight column of the Sales table with the following measure:
Min freight = MINA(Sales[Freight])
Category
Statistical