Returns the largest numeric value in a column, or between two scalar expressions.


MAX(<expression1>, <expression2>)


Term Definition
column The column in which you want to find the largest numeric value.
expression Any DAX expression which returns a single numeric value.

Property Value/Return value

A decimal number.


When evaluating a single column that contains numeric values, if the column contains no numbers, MAX returns a blank. If you want to evaluate values that are not numbers, use the MAXA function.

When comparing two expressions, blank is treated as 0 when comparing. That is, Max(1, Blank() ) returns 1, and Max( -1, Blank() ) returns 0. If both arguments are blank, MAX returns a blank. If either expression returns a value which is not allowed, MAX returns an error.


The following example returns the largest value found in the ExtendedAmount column of the InternetSales table.



The following example returns the largest value between the result of two expressions.

=Max([TotalSales], [TotalPurchases])

See also

MAX function (DAX)
MAXA function (DAX)
MAXX function (DAX)
Statistical functions (DAX)