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


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

Formula examples using the MAXA function


= MAXA (


Related DAX Functions

Related Course Modules



Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.

Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide