Create offline cube files (.cub) with OlapCube. Download Now!

table of contents


Returns a set of members prior to and including a specified member.


LastPeriods(«Index»[, «Member»])


If «Member» is not specified, it is Time.CurrentMember.

If «Index» is positive, returns the set of «Index» members ending with «Member» and starting with the member lagging «Index» - 1 from «Member».

If «Index» is negative, returns the set of (- «Index») members starting with «Member» and ending with the member leading (- «Index» - 1) from «Member».

If «Index» is zero, the empty set is returned.


The following table lists possible uses of the LastPeriods function.

Expression Returns
LastPeriods(2, [1997June])
{[1997May], [1997June]}
LastPeriods(-2, [1997June])
{[1997June], [1997July]}
LastPeriods(1, [1997June])
LastPeriods(-1, [1997June])
LastPeriods(0, [1997June])
Empty set