SQL Server Analysis Services MDX Average Calculation
User Rating: / 0
PoorBest 
Written by Dallas Snider   
Wednesday, 04 December 2013 21:24

How can you calculate an average in SQL Server MDX? Can calculating an average in MDX be accomplished in multiple ways? Check out this tip to learn more.

Solution

The solution presented in this tip was created in SQL Server Management Studio. The AVG function in SQL Server MDX allows for the calculation of an average measure over a specified set of dimension values.

Read more...

 

Tags: mdx
 

Pyramid Analytics