MAXX

Syntax

MAXX(<table>,<expression>)

Tutorial with example

In today’s video we will go through the DAX functions of MAX, MAXX and MAXA.

Example 2:

Find the highest value of a series:

Download example file:

Download Power BI file: here.

Remarks

The table argument to the MAXX function can be a table name, or an expression that evaluates to a table. The second argument indicates the expression to be evaluated for each row of the table.

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. If you want to include non-numeric values in the formula, use the MAXA function.

If a blank cell is included in the column or expression, MAXX returns an empty column.