MAX Function (DAX)
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
MAX(
<column>
)
MAX(
<expression1>,<expression2>
)
How do you use the MAX function?
Largest value in the column or in both expressions.
Related Blog Posts
Related Support Forum Posts
Find the max in a column function
Difference between MAX and LastDate
DAX Calculation – Using MAX Issue
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 (
InternetSales[ExtendedAmount]
)
= MAX (
[TotalSales], [TotalPurchases]
)