Hello All:

I have the following Calculated Member that works with one "Time" dimension
(called As Of Date). However I need to add another "Time" dimension to this
equation (called "Calendar").

The end user will enter 2 dates (a specific date for "As Of Date" & and
Range of dates for "Calendar"). There are 2 requirements here:
1. For a specific "AS OF Date" entered (in psuedocode -- get the MAX(of the
available As OF Date <= date entered). I have been able to get this piece as
below:

iif(
NOT IsEmpty(
([As Of Date].[As Of Dates],[Measures].[Census Count])),
([As Of Date].[As Of Dates],[Measures].[Census Count]),
iif(
[As Of Date].[As Of Dates].Prevmember IS NULL,
NULL,
([As Of Date].[As Of Dates].Prevmember))
)

2. From the "Calendar" date range entered (say "date1" to "date2") I need to
be able to select the date member PRIOR to "date1".

The final result should give me a "sort of CROSSJOIN" of the AS OF Date &
the date1 (prior member).

Anyhelp is greatly appreciated.
--
Thank you,
Ashok G