Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Aggregate function. Returns the average value of a numeric expression evaluated over a set.

Syntax

 Avg( Set_Expression , Numeric_Expression )

Arguments

Set_Expression
MDX expression that returns set.
Numeric_Expression
MDX expression that returns a number.

Returns

Number
Average value of Numeric_expression over set

Example

The following example finds the average Item base amount in the last 52 weeks.

Avg(
  {[Time.Weekly].[Week].CurrentDateMember.Lag(52): 
   [Time.Weekly].[Week].CurrentDateMember.PrevMember},
  CoalesceEmpty(
  ([Measures].[Item base amount],[Time].DefaultMember),
   0)
)
  • No labels