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

## Formula examples using the MAX function

=MAX (
InternetSales[ExtendedAmount]
)

= MAX (
[TotalSales], [TotalPurchases]
)

## Related Course Modules 