Syntax
Tutorial with example
In today’s video we will go through the DAX functions of MAX, MAXX and MAXA.
Download example file:
Not available
Example 2: Find the highest and lowest value
Find the highest value of a series:
Download example file:
To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #128
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.
Leave a Reply