Re: Recency, time since last sale

As far as the MDX goes, you could substract index positions of two dates.
It would mean that you find index position of last purchase date in the date
dimension and then find index position of 'today' or some other date...


MC


"Jacob_I" <JacobI@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5C0C8187-C289-4E36-92BE-11F711D5B6E1@xxxxxxxxxxxxxxxx
> Hi Mike
>
> Actually, I didn't think about that at all. I'll try that and post my
> findings.
>
> "mike" wrote:
>
>> have you tried using vba functions? DateDiff() and CDate() ??
>>
>> "Jacob_I" wrote:
>>
>> > Hi,
>> >
>> > I'm trying to implement a recency measure for my individual customers,
>> > telling me how many days have gone by since the last purchase of a
>> > customer.
>> > I would like it to go something like this:
>> >
>> > with member time.week.last_purchase_date as
>> > 'Tail(Filter([Time].[Week].[Date].members, Not
>> > IsEmpty(([Measures].[Quantity],[Customers].[Geography].CurrentMember)))).Item(0).Item(0).uniquename
>> > '
>> >
>> > member measures.days_since_last_purchase as
>> > 'Datediff(time.week.lastpurchasedate : [Time].[Week].Currentmember)'
>> >
>> > Of course there is no Datediff in MDX, but how can I construct the
>> > syntax to
>> > meet my requirements?
>> >
>> > Many thanks!


.

Loading