MAXA Function (DAX)

How does the MAXA function (DAX) work?

The MAXA function (DAX) returns the greatest value in a column. Does not ignore logical values and text.

MAXA Formula Syntax

MAXA(
     <ColumnName>
)

How do you use the MAXA function?

The MAXA function corresponds to MAX used as argument for all data types except for Boolean with a single column. When operating with a Boolean data type, MAXA considers TRUE to be 1 and FALSE to be 0.

The MAXA function executes MAXX internally for arguments which are not boolean, without any difference in performance.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the MAXA function

Empty cells are ignored. If no values can be used in the column, then MAXA returns 0 (zero).

If the text values are to be compared, use the MAX function.

Related Video Tutorials

Ultimate Beginners Guide to DAX
What-Is-DAX-Why-Do-You-Need-To-Learn-It-1.2-Ultimate-Beginner-Guide-to-DAX

Formula examples using the MAXA function

=MAXA (
     [ResellerMargin]
)

= MAXA (
    [TransactionDate]
)

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.