Table of contents
Collapse the table of content
Expand the table of content

MAX Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
1 Contributor

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.

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)

© 2018 Microsoft