Hi George,

I'm glad you figured it out - apologies, I had gone home for the weekend and I don't even like to think about this sort of thing at the weekend 😀

Your code will do it but I have to say I'm not a fan of those hard-coded dates. Perhaps consider adding an attribute to your date dimension (either in the SQL table or as a Calculated Member in the data source view) for something like TermStart as a boolean. You could then construct your MDX to be far more dynamic.

As you're new to MDX, I can think of no better guide to not only the language but the concept of MDX than the guide by Frank Banin on this very site: http://www.sqlservercentral.com/articles/MDX/91228/

Good luck 🙂