May 29, 2015 at 3:11 am
Hi everyone,
Is it possible to create set based on currentmember? For ex, if user selected May 2015, the set will return the previous 12 months?
May 2015
Apr 2015
...
Jun 2014
Thanks for the help!
May 30, 2015 at 10:30 am
A couple of ways this can be done......
with LAG:
or with VBA Now() and DateAdd:
http://mikedavissql.com/2013/07/22/creating-a-rolling-date-range-named-set-in-mdx/
May 30, 2015 at 10:36 am
Hi PB_BI,
What I needs is a set that returns the last x months, and not a measure to calculate values for past x months.
Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply