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

MAX(
     <column>
)

MAX(
     <expression1>,<expression2>
)

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
What-Is-DAX-Why-Do-You-Need-To-Learn-It-1.2-Ultimate-Beginner-Guide-to-DAX

Formula examples using the MAX function

=MAX (
     InternetSales[ExtendedAmount]
)

= MAX (
    [TotalSales], [TotalPurchases]
)

 

Related DAX Functions

MAXA
MAXX
 

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI