MAX – DAX Guide

Returns the largest value in a column, or the larger value between two scalar expressions. Ignores logical values. Strings are compared according to alphabetical order.

The second value to compare.

The column in which you want to find the largest value, or the first scalar expression to compare.

Largest value found in the column or in the two expressions.

Scalar A single value of any type.

Remarks

When used with a single column, the MAX function internally executes MAXX, without any performance difference.
The following MAX call:

MAX ( table[column] )

corresponds to the following MAXX call:

MAXX (
    table,
    table[column] 
)

The result is blank in case there are no rows in the table with a non-blank value.

When used with two arguments, the syntax:

MAX ( exp1, exp2 )

corresponds to:

VAR v1 = exp1
VAR v2 = exp2
RETURN IF ( 
    v1 > v2, 
    v1, 
    v2 
)