Date calculation

Hi All,

I have the following situation:
- date dim (on month level)
- plandate dim
- project dim
- projectstate dim
- amount measure

Each project has a plandate and at that date a certain amount in planstate x.
For example, project x has a plandate of 04-21-2008, a planstate of B and
amount 1000.

What I want is a calculated member which calculates the amount of the
plandate until the end of the year. So the produced results should be:


Project X
Plandate 04-21-2008
Planstate B

Date Calculation
01-2008
02-2008
03-2008
04-2008 1000
05-2008 1000
06-2008 1000
07-2008 1000
08-2008 1000
09-2008 1000
10-2008 1000
11-2008 1000
12-2008 1000

I know this should not be too difficult but
I cannot find the solution

Any ideas?

Q