Skip to content

Latest commit

 

History

History
58 lines (38 loc) · 1.56 KB

mina-function-dax.md

File metadata and controls

58 lines (38 loc) · 1.56 KB
Raw
description title
Learn more about: MINA
MINA function (DAX) | Microsoft Docs

MINA

[!INCLUDEapplies-to-measures-columns-tables-visual-calculations]

Returns the smallest value in a column.

Syntax

MINA(<column>)

Parameters

Term Definition
column The column for which you want to find the minimum value.

Return value

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.

  • [!INCLUDE function-not-supported-in-directquery-mode]

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 content

MIN function
MINX function
Statistical functions