Hi,

I need to calculate the average of one of my measure (called NetSales) for the last 3 months as per the following logic:

If my selected time period is Dec, then I want to get the average of the NetSales for Sep, Oct., and Nov.

I have tried using the LastPeriods function (as follows) but that returns the average of Oct., Nov., and Dec.

AVG(LastPeriods (3, [Time].CurrentMember), [Measures].[NetSales])

Any idea how I can get the desired result.

Many thanks in advance.

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

AVG(LastPeriods (3, [Time].CurrentMember.PrevMember), [Measures].[NetSales])

Ohjoo Kwon


"Learner" <wantnospam (AT) email (DOT) com> wrote

Hi Ohjoo,

Tons and millions (make it billions) of thanks. That does the trick

Can you plese guide me to some good resource from where I can also get a good hang of MDX.

Regards.

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

I recommend the related books.

1. "Fast Track to MDX" by Mark Whitehorn, Mosha Pasumansky, Robert Zare
2. "MDX Solutions: With Microsoft SQL Server Analysis Services" by George
Spofford

Also, the home page of Mosha Pasumansky, the development lead for the
Microsoft Analysis Services engine.

http://www.mosha.com/msolap/


Ohjoo


"Learner" <wantnospam (AT) email (DOT) com> wrote