I have to make a Calculated Measure for the Rolling(Moving) Average of the
last 7 Days sales

I have the following formula
AVG(LASTPERIODS(3), [Store Sales] which returns any period rolluup
but i want to calculate only on day not on any period even though i might be
standing on Month,Quartor or any other Level

Do you mean it displays null on other level than day? If then, you try IIF()
function.

IIF(Time.CurrentMember.Level.Name = "Day", Avg(....), NULL)

Ohjoo Kown
www.olapforum.com


"Burhan" <burhanuddin.ahmed (AT) gonetbpo (DOT) com> wrote

it does not return null, in fact it displays result on other levels as well
but i myself want it to be calucated on basis of day only even when i am on
quarters or any other level.
Furthermore, can you help me with another problem. i want to cacluate a
metric called acquisition rate whereby i want to know how many new customers
have been acquired in any period, be it day, week, month etc. what would be
right way of doing it and which function should i use for it. i have
inserted all customers record in the fact table.

----- Original Message -----
From: "Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr>
Newsgroups: microsoft.public.sqlserver.olap
Sent: Thursday, February 17, 2005 10:02 PM
Subject: Re: Rolling Average






"Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> wrote