MINA Function (DAX)

How does the MINA function (DAX) work?

MINA function returns a column with the smallest value. Does not ignore both logical and text values.

MINA Formula Syntax

= MINA(
     <column>
)

How do you use the MINA function?

The MINA function corresponds to the MIN used for all data types except for Boolean with a single column as argument. When working with a Boolean data type MINA considers TRUE to be 1 and FALSE to be 0.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions
Getting started with DAX: DAX function types

Considerations when using the MINA function

The MINA function takes a column containing numbers as its argument, and calculates 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.

Use the MIN function if you want to compare text values.

Related Video Tutorials

Formula examples using the MINA function

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

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership