MAX
The largest value in a column, or the larger of two values (a blank comparing as zero).
Group: Aggregation. Compatible with DAX.
Syntax
MAX ( <column> )
MAX ( <expression1>, <expression2> )| Parameter | Type | Description |
|---|---|---|
column | Column | The column whose largest value is wanted: numbers, dates or text. |
expression1 | Value | The first of two values to compare. |
expression2 | Value | The second of two values to compare. |
Returns
Same type as its values. The largest value: of the column's cells, or of the two values given.
Remarks
- With a column, blanks are left out; with no value in the filter context the result is BLANK.
- With two values, a blank compares as zero:
MAX ( -2, BLANK () )is blank, as blank is the larger. - Text is compared without regard to case. Two values of different types, such as a number and a text, are an error.
- For the largest value of an expression over rows, use
MAXX.
Examples
The last month with sales, and the largest month
EVALUATE
ROW (
"Last month", MAX ( Sales[Month] ),
"Most liters in a month", MAX ( Sales[Liters] )
)| Last month | Most liters in a month |
|---|---|
| 2026-10-01 | 6033 |
The larger of two values
With a blank against a negative number, the blank (as zero) is larger.
EVALUATE
ROW (
"Of 4 and 9", MAX ( 4, 9 ),
"Of -2 and blank", MAX ( -2, BLANK () )
)| Of 4 and 9 | Of -2 and blank |
|---|---|
| 9 | (blank) |