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

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
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

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

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.