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

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Proffesore Valued Member Points: 57 More actions · Answer 1

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?

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 2

SSC Guru

Points: 76202

June 25, 2015 at 8:06 am

Thanks for the continuing series.