Power Fx function
Min / Max — Power Fx function reference
Smallest or largest value.
Syntax
powerfx
Min( Table, Formula ) / Max( Table, Formula )
Examples
powerfx
Max(Orders, Amount)
→ A number
powerfx
Max(Orders, Amount) - Min(Orders, Amount)
powerfx
Max(dueDate1, dueDate2, dueDate3)
Common mistakes & gotchas
- Both work on dates as well as numbers, and can compare a fixed list of scalar values without needing a table, as in the second example.
- Neither is delegable on most tabular connectors — wrap the source in a delegable Filter/Sort first, or the result only reflects locally retrieved rows.
Related Power Fx functions
From Math & aggregation