MINA

Updated on
Rick de Groot

MINA is a DAX function that returns the smallest value in a column, including logical values and text.

Syntax

MINA( ColumnName )
Argument Properties Description
ColumnName The column for which you want to find the smallest value.

Return Values

The smallest value.

Remarks

  • The MINA function takes as argument a column that contains numbers, and determines the smallest value as follows:

    • If the column contains no values, MINA returns 0 (zero).
    • Rows in the column that evaluates to logical values, such as TRUE and FALSE are treated as 1 if TRUE and 0 (zero) if FALSE.
    • Empty cells are ignored.

  • If you want to compare text values, use the MIN function.

  • This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Example 1

The following expression returns the minimum freight charge from the table, InternetSales.

= MINA(InternetSales[Freight])

Example 2

The following expression returns the minimum value in the column, PostalCode. Because the data type of the column is text, the function does not find any values, and the formula returns zero (0).

= MINA([PostalCode])

Other functions related to MINA are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/mina-function-dax

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy