MAXA
The largest value in a column, text counting as 0, TRUE as 1 and FALSE as 0.
Group: Aggregation. Compatible with DAX.
Syntax
MAXA ( <column> )| Parameter | Type | Description |
|---|---|---|
column | Column | The column whose largest value is wanted; it may hold numbers, text or logical values. |
Returns
Number. The largest value, where text counts as 0, TRUE as 1 and FALSE as 0.
Remarks
- Blank cells are left out.
- On a column of numbers it gives the same answer as
MAX; on a column of text, 0.
Examples
Numbers and text
EVALUATE
ROW (
"Highest price", MAXA ( Holdings[Price] ),
"Of the names", MAXA ( Products[Product] )
)| Highest price | Of the names |
|---|---|
| 101.3 | 0 |