MAXX DAX Function (Aggregation)
Returns the largest value that results from evaluating an expression for each row of a table. Strings are compared according to alphabetical order.
Syntax
MAXX ( <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.
Largest value found in the expression.
Related articles
Learn more about MAXX 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: Aug 1, 2020 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Jes Hansen
MSDN documentation: https://docs.microsoft.com/en-us/dax/maxx-function-dax