Calculates the average (arithmetic mean) of a set of expressions evaluated over a table.
AVERAGEX (<table>, <expression>)
|Sr.No.||Parameter & Description|
Name of a table, or an expression that specifies the table over which the aggregation can be performed.
An expression with a scalar result, which will be evaluated for each row of the table in the first argument.
A decimal number.
The AVERAGEX function enables you to evaluate expressions for each row of a table, and then take the resulting set of values and calculate its arithmetic mean. Therefore, the function takes a table as its first argument and an expression as the second argument.
In all other respects, AVERAGEX follows the same rules as AVERAGE. You cannot include non-numeric or null cells.
= AVERAGEX (East_Sales,East_Sales[Unit Price]*East_Sales[No. of Units])
26 Lectures 4.5 hours