Tutorial with example
In today’s video we will go through the DAX functions of MAX, MAXX and MAXA.
Find the highest value of a series:
Download example file:
Download Power BI file: here.
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).
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.