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

Related Support Forum Posts

Find the max in a column function
Difference between MAX and LastDate
DAX Calculation – Using MAX Issue

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



To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.