RE: Stairway to MDX Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions

Valued Member

Points: 57

June 3, 2015 at 3:47 am

This Topic helped me a lot.I would like to thank the author.

I would like to get a sum of a measure X for the currentyear but without the current month.Moreover I would like this to hapen dynamic.

I am getting the current month from

WITH
SET [Current Month] AS
strtomember("[TIME].[MONTH].&[" + CSTR(YEAR(NOW())) + "-"+ RIGHT("0" + CSTR(MONTH(NOW())), 2) +"-01T00:00:00]")

Any thoughts?