Hi all
This seems like an easy problem to me - by I'm struggling to find the
right MDX expression.

My Analysis Services database analyses sales of product to retail
customers

I simply want to put a calculated measure on to the server called
"last 3 months average rate of sale"
- and track this measure over time to highlight trends

The standard average expression:
avg(lastperiods(3,[time].currentmember),[quantity])
works fine most of the time

But what if we sell a new product!
In the first month, I want the average to be [quantity] / 1
In the second month, it will be [quantity] / 2
Only in the third month do I want to resume a 3 month average.

I suppose that "count" and "excludeempty" are in the solution
somewhere - but that's as far as I've got...

I'll be gratefull for any help on this

Thanks

Ian Bamforth

The average function does not take into account empty
cells.
So your formula will do what you want as is, as long as
you do not fill saleless periods with zeroes.
HTH,
Brian