Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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])