Average
Aggregation
Returns average of all the numbers in column.
Parameters
column -> Column
The column for which average needs to be calculated
Returns
Type: decimal
Returns decimal value which is mean of all numbers from column
Details
- Returns blank if column contains text.
- Zeroes are counted toward average count but blank values are ignored.
Examples
The following formula returns average of CurrentSalaray from Employee table.
= AVERAGE(Employee[CurrentSalary])