AverageA
Aggregation
Returns average of all the values in column. Handles non-numeric values unlike Average
Parameters
column -> Column
The column for which average needs to be calculated
Returns
Type: decimal
Returns decimal value which is mean of all the values from column
Details
- Handling of non-numeric types
- Values that evaluate to True are counted as 1.
- Values that evaluate to True are counted as 0.
- Values that contain text values are counted as 0.
- Returns blank if there are no rows
Examples
The following formula returns average of CurrentSalaray from Employee table.
= AVERAGE(Employee[CurrentSalary])