LastPeriods

hello,

i trying retrieve last 3 periods current month (ie sept, oct, nov).  thinking lastperiods function might work, getting following error "the lastperiods function expects member expression 0 argument. tuple set expression used."  here's code.

select { lastperiods (3, tail(nonempty([week].[week].[week name].members)) ) } on columns from [gmdsummary]

maybe ?

 select { lastperiods (3, tail(nonempty([week].[week].[week name].members)).item(0).item(0) ) } on columns from [gmdsummary]

SQL Server  >  SQL Server Analysis Services