title: MDX and AVG function
body: <p>Not sure if this is the right place for MDX question but it seemed to be the most appropriate.</p>
  
  <p>I have a question about MDX and the AVG function.</p>
  
  <p>I would like to compute the average sale amount by day across several month for a year.</p>
  
  <p>So I would like to compute the AVG of the 2010/01/01, 2010/02/01, 2010/03/01, etc... and this for everyday of the month.</p>
  
  <p>Can anyone give me a hint on how I'd be able to do that ?</p>
  
  <p>I would go for something that looks like this</p>
  
  <p><code>WITH MEMBER [Measures].[Total] AS AVG(DESCENDANTS([Time].[2010], [Day]),[Measure].[Sale])</code></p>
  
  <p>Thank you,</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>I have open a new question with a clearer explanation of my problem and study case.</p>
  
  <p>Please find it at : <a href="https://stackoverflow.com/questions/6175962/mdx-avg-advanced-use">MDX: avg advanced use</a></p>