MDX101: Set

Showing posts with label Set. Show all posts

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")+ "]")}