"Jacob_I" <JacobI@discussions.microsoft.com> wrote in message
news:5C0C8187-C289-4E36-92BE-11F711D5B6E1@microsoft.com...
> 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!

> ..the [Time].[Week].[Date].members is replaced by a set of members that
> looks something like ([time].[week].(All):[Time].[week].Currentmember) ie. it
> returns all members from beginning of time until time.currentmember.
>

"Jacob_I" wrote:

> Thanks a lot Mike & MC. I've gotten the datediff stuff working beautifully
> thansk to you valuable advice. But I also need it to be time-sensitive, so
> that when I use the calc member:
>
> 'Tail(Filter([Time].[Week].[Date].members, Not
> IsEmpty(([Measures].[Quantity],[Customers].[Geography].CurrentMember)))).Item(0).Item(0).uniquename '
>
> ..the [Time].[Week].[Date].members is replaced by a set of members that
> looks something like ([time].[week].(All):[Time].[week].Currentmember) ie. it
> returns all members from beginning of time until time.currentmember.
>
> Can this be done? Maybe it's woth a new thread?
>
> Thanks in advance!
>
> Regards, Jacob
>
>