Power Fx function
Average — Power Fx function reference
Mean of a column.
Syntax
powerfx
Average( Table, Formula ) / Average( Number1, Number2, ... )
Examples
powerfx
Average(Orders, Amount)
→ A number
powerfx
Average(Filter(Reviews, ProductID = ThisItem.ID), Rating)
powerfx
Average(score1, score2, score3)
Common mistakes & gotchas
- Average ignores blank values rather than treating them as zero — a mostly-empty column can produce a higher average than expected.
- Same non-delegation caveat as Sum: on large tabular sources it only averages the locally retrieved rows.
Related Power Fx functions
From Math & aggregation