MINA

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])

MINE function. Example of use
Related functions
Category
Statistical
Submitted by admin on Mon, 01/21/2019 - 13:49