MDX101
My collection of how to use MDX in a SSAS 2012 / 2014 environment.
Tuesday, March 13, 2018
Past 12 months dynamic
{
StrToMember
(
"[Kalender].[J4MND].[Jaar 4MND Maand].&["
+
Format
(DATEADD(
"M"
,-1,now()),
"yyyyMM"
)+
"]"
).
Lag
(11):
StrToMember
(
"[Kalender].[J4MND].[Jaar 4MND Maand].&["
+
Format
(DATEADD(
"M"
,-1,now()),
"yyyyMM"
)+
"]"
)}
No comments:
Post a Comment
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment