Tutorial with example
In today’s video we will go through the DAX functions of MAX, MAXX and MAXA.
Download example file:
The MAXA function takes as argument a column, and looks for the largest value among the following types of values:
- Logical values, such as TRUE and FALSE. Rows that evaluate to TRUE count as 1; rows that evaluate to FALSE count as 0 (zero).
Empty cells are ignored. If the column contains no values that can be used, MAXA returns 0 (zero).
If you do not want to include logical values and blanks as part of the calculation, use the MAX function.
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.