MAX
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns the largest value in a column, or between two scalar expressions.
Syntax
MAX(<column>)
MAX(<expression1>, <expression2>)
Parameters
| Term | Definition |
|---|---|
| column | The column in which you want to find the largest value. |
| expression | Any DAX expression which returns a single value. |
Return value
The largest value.
Remarks
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 which is not allowed, MAX returns an error.
TRUE/FALSE values are not supported. If you want to evaluate a column of TRUE/FALSE values, use the MAXA function.
Example 1
The following example returns the largest value found in the ExtendedAmount column of the InternetSales table.
= MAX(InternetSales[ExtendedAmount])
Example 2
The following example returns the largest value between the result of two expressions.
= Max([TotalSales], [TotalPurchases])