Question to create Measure for prior sale year and month

Hi All,

I have started with SSAS last week and getting into several options. I came across following difficulty. Please help if you have any ideas.

I’m building a report that has attributes A1, A2, A3, Year and Month and measures M1 and M2

A1

A2

A3

Year

Month

M1

M2

The M1 value is such that it is M2 of Month 6 of Year – 3.

For example, for Year 2007, month 3 the value of M2 is 100

And for year 2004, month 6 the value of M2 is 66

Then the report would be like

A1

A2

A3

Year

Month

M1

M2

a

b

c

2007

3

66

100

How to create M1 measure ?

Thanks in advance.

Sorry, but I don't quite follow what M1 represents? Is M1 the M2 value at a point in time that is 3 years prior to the current point in time?

Thanks,
Bryan

sql