Share via


MAX Function (DAX)

Returns the largest numeric value in a column.

MAX(<column>)

Parameters

Term

Definition

column

The column in which you want to find the largest numeric value.

Property Value/Return Value

A number (R8).

Remarks

The MAX function takes as an argument a 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.

Example

The following example returns the largest value found in the ExtendedAmount column of the InternetSales table.

=MAX(InternetSales[ExtendedAmount])

See Also

Other Resources

MAX Function (DAX)

MAXA Function (DAX)

MAXX Function (DAX)

Statistical Functions (DAX)