MAX Function (DAX)


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


MAX(<expression1>, <expression2>)


columnThe column in which you want to find the largest numeric value.
expressionAny DAX expression which returns a single numeric 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])

MAX Function (DAX)
MAXA Function (DAX)
MAXX Function (DAX)
Statistical Functions (DAX)

Community Additions