I have a dynamic query i use with reporting services to select different time
values based on a drop down.

I can select the current month, the last 2 months, the current quarter, or
the last 2 quarters.

the "time" sections of my queries are as follows
(time structure Year->quarter->month)

current month: LastPeriods(1,[FiscalDate].LastChild.LastChild.LastChild)
last two months: LastPeriods(2,[FiscalDate].LastChild.LastChild.LastChild)
current quarter: LastPeriods(1,[FiscalDate].LastChild.LastChild)
last 2 quarters: LastPeriods(2,[FiscalDate].LastChild.LastChild)

everything works fine.

I need to change to current month, previous month, current quarter, previous
quarter

I chnaged my last 2 months and last 2 quarters queries to this:

previous month:
LastPeriods(1,[FiscalDate].LastChild.LastChild.LastChild.PrevMember)

previous quarter: LastPeriods(2,[FiscalDate].LastChild.LastChild.PrevMember)

Should this work? It seems to return the same values as last 2 months, and
last 2 quarters returned.

Is there a better way to select "the month before the current month of the
year"?

Thanks

Seems like what you're doing should work, though you can try
ClosingPeriod(), like in this Foodmart example:


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***