How does the MAX function (DAX) work?
The MAX function (DAX) returns a column’s largest value, or between two scalar expressions.
MAX Formula Syntax
How do you use the MAX function?
Largest value in the column or in both expressions.
Related Blog Posts
Related Support Forum Posts
Considerations when using the MAX function
When comparing two expressions, blank is treated as 0 when comparing. That is, Max(1, Blank() ) returns 1, and Max( -1, Blank() ) returns 0. If both arguments are blank, MAX returns a blank. If either expression returns a value that is not allowed, MAX returns an error.
No support for the TRUE / FALSE values. Use the MAXA function if you want to evaluate a column of TRUE / FALSE values.
Related Video Tutorials
Formula examples using the MAX function
= MAX (
Related DAX Functions
Related Course Modules
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.