MINX DAX Function (Aggregation)
Returns the smallest value that results from evaluating an expression for each row of a table. Strings are compared according to alphabetical order.
Syntax
MINX ( <Table>, <Expression> )
| Parameter | Attributes | Description |
|---|---|---|
|
Table Iterator |
The table containing the rows for which the expression will be evaluated. |
|
|
Expression Row Context |
The expression to be evaluated for each row of the table. |
Return values
Scalar A single value of any type.
Smallest value found in the expression.
Related articles
Learn more about MINX in the following articles:
-
Highlighting the minimum and maximum values in a Power BI matrix
This article shows how to use DAX and conditional formatting together to highlight the minimum and maximum values in a matrix in Power BI. » Read more
Related functions
Other related functions are:
Last update: Jul 8, 2020 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Jes Hansen
MSDN documentation: https://docs.microsoft.com/en-us/dax/minx-function-dax