MAX

Syntax

MAX(<column>)

MAX(<expression1>, <expression2>)

Tutorial with example

In today’s video we will go through the DAX functions of MAX, MAXX and MAXA.

Download example file:

Not available

Remarks

When evaluating a single column that contains numeric values, if the column contains no numbers, MAX returns a blank. If you want to evaluate values that are not numbers, use the MAXA 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 which is not allowed, MAX returns an error.