MAX Function (DAX)

How does the MAX function (DAX) work?

The MAX function (DAX) returns a column’s largest value, or between two scalar expressions.

MAX Formula Syntax



How do you use the MAX function?

Largest value in the column or in both expressions.

Related Blog Posts


Considerations when using the MAX 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 that is not allowed, MAX returns an error.

No support for the TRUE / FALSE values. Use the MAXA function if you want to evaluate a column of TRUE / FALSE values.

Related Video Tutorials

Ultimate Beginners Guide to DAX

Formula examples using the MAX function

=MAX (

= MAX (
    [TotalSales], [TotalPurchases]


Related DAX Functions


Related Course Modules