TechNet
Export (0) Print
Expand All

MAX Function (DAX)

 

Returns the largest numeric value in a column.

MAX(<column>)  

Parameters

TermDefinition
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(InternetSales[ExtendedAmount])  

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

Community Additions

Show:
© 2016 Microsoft