The AVERAGE function returns the arithmetic mean of the values in a column.
Syntax
AVERAGE(
<column>
)
Parameters
- column: Name of the column for which you want to calculate the arithmetic mean.
Returned value
The AVERAGE function returns a real number.
Additional Information
Cells that contain zeros are included in the calculation. Cells containing non-numeric values or empty cells are ignored.
Examples
The measure
Average value = AVERAGE(FactSales[SalesAmount])
returns the average value of the sales amounts contained in the SalesAmount column of the FactSales table.
Category
Statistical
