- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
DAX Aggregation - MAXX function
Description
Evaluates an expression for each row of a table and returns the largest numeric value.
Syntax
MAXX (<table>, <expression>)
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
table The table containing the rows for which the expression will be evaluated. |
2 |
expression The expression to be evaluated for each row of the table that returns a numeric value. |
Return Value
Returns a decimal number.
Remarks
Of the values to evaluate, only the following are counted −
Numbers. If the expression does not evaluate to a number, MAXX returns 0 (zero).
Dates.
Empty cells, logical values, and text values are ignored.
Example
= MAXX (East_Sales,East_Sales[No. of Units]*East_Sales[Unit Price])
dax_functions_aggregation.htm
Advertisements