MAX Function
Returns the largest numeric value in a column.
Syntax
MAX(<column>)
Parameters
Term |
Definition |
|---|---|
column |
The column in which you want to find the largest numeric value. |
Property Value/Return Value
A decimal number.
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])