MAX Function (DAX)


Returns the largest numeric value in a column.



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

A decimal number.

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.

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


MAX Function (DAX)
MAXA Function (DAX)
MAXX Function (DAX)
Statistical Functions (DAX)

Community Additions