Depending on the naming of your day members, you can construct a string
that represents today's date (using VBA functions like Date and Format
as necessary). Then, you can convert the string to a day member, and
take 10 previous:

LastPeriods(10, StrToMember("TodayString").PrevMember)


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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