TechNet
Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Collapse the table of content
Expand the table of content
Expand Minimize

StdevP (MDX)

 

Updated: March 2, 2016

Returns the population standard deviation of a numeric expression evaluated over a set, using the biased population formula (dividing by n).

  
StdevP(Set_Expression [ ,Numeric_Expression ] )  

Set_Expression
A valid Multidimensional Expressions (MDX) expression that returns a set.

Numeric_Expression
A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number.

The StdevP function uses the biased population formula, while the Stdev function uses the unbiased population formula.

The following example returns the standard deviation for Internet Order Quantity evaluated over the first three months of calendar year 2003 using the biased population formula.

WITH MEMBER Measures.x AS   
   StdevP   
   ( { [Date].[Calendar].[Month].[January 2003],  
       [Date].[Calendar].[Month].[February 2003],  
       [Date].[Calendar].[Month].[March 2003]},  
    [Measures].[Internet Order Quantity])  
SELECT Measures.x ON 0  
FROM [Adventure Works]  

MDX Function Reference (MDX)

Community Additions

ADD
Show:
© 2016 Microsoft