Returns the highest value in a list. If
list is an empty list of numerical values, returns 0.
MAX(Products[Price]) returns the highest of all values in the
Price column of the
Products table. Equivalent to
MAX(SELECT(Products[Price], TRUE)). See also:
MAX([Discounts])returns the highest of the items in the
Discounts column value, where
Discounts is of type
MAX(LIST(1, 2, 3)) returns
Highest from select values
Highest discount given to non-employees within the past month:
MAX( SELECT( Sales[Discount Amt], AND( NOT([Customer].[Is Employee?]), ([Sale Date] > ( EOMONTH(TODAY(), -2) + DAY(TODAY()) )) ) ) )
SELECT(Sales[Discount Amt], ...)returns a list of values from the
Discount Amtcolumn from rows of the
AND(..., ...)limits the values returned to only those from rows that match all of the given conditions.
NOT([Customer].[Is Employee?])excludes those rows with a
Customercolumn value that refers to a customer record that indicates the customer is also an employee.
[Sale Date] > ...includes only those rows with a
Sale Datecolumn value later than the computed date.
EOMONTH(TODAY(), -2) + DAY(TODAY())computes the date for one month ago today.
MAX(...)returns the highest value in the select list of
MAX(1, 2, 3) In this example, the arguments are not in list form. To fix, wrap them in
LIST() to construct a list:
MAX(LIST(1, 2, 3)).
list- List of any numeric type.
AppSheet must be given enough context to determine what type of values
list contains, that its contents are or will be numeric. To that end,
list must be one of the following: a column value of type
List that contains numeric values; a column list (for example,
Products[Price]) for a column of a numeric type; or a constructed list (for example, with
LIST()) of a numeric type.