DAX function
MIN / MAX — DAX function reference
Smallest or largest value.
Syntax
dax
MIN(<column>) / MIN(<expr1>, <expr2>) MAX(<column>) / MAX(<expr1>, <expr2>)
Examples
dax
MAX(Sales[Amount])
→ A number
dax
MAX(Sales[Amount]) - MIN(Sales[Amount])
→ Range of order values in the current context
MIN/MAX also accept two scalar expressions and return the larger/smaller of the two, not just a column aggregation.
dax
MAX(0, [Variance])
→ Floors a variance measure at zero
Common mistakes & gotchas
- MIN/MAX on a column respects the current filter context; wrap in CALCULATE with ALL() to get the true global min/max instead of the visual’s local one.
- The two-argument scalar form (MAX(a, b)) is a different overload from the single-column aggregation form — don't confuse it with MAXX.
Related DAX functions
From Aggregations