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


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide