**THIS TOPIC APPLIES TO:**SQL Server (starting with 2008)Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse

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

## Syntax

```
LastPeriods(Index [ ,Member_Expression ] )
```

## Arguments

*Index*

A valid numeric expression that specifies a number of periods.

*Member_Expression*

A valid Multidimensional Expressions (MDX) expression that returns a member.

## Remarks

If the specified number of periods is positive, the **LastPeriods** function returns a set of members that start with the member that lags *Index* - 1 from the specified member expression, and ends with the specified member. The number of members returned by the function is equal to *Index*.

If the specified number of periods is negative, the **LastPeriods** function returns a set of members that start with the specified member and ends with the member that leads (- *Index* - 1) from the specified member. The number of members returned by the function is equal to the absolute value of *Index*.

If the specified number of periods is zero, the **LastPeriods** function returns the empty set. This is unlike the **Lag** function, which returns the specified member if 0 is specified.

If a member is not specified, the **LastPeriods** function uses **Time.CurrentMember**. If no dimension is marked as a Time dimension, the function will parse and execute without an error, but will cause a cell error in the client application.

## Examples

The following example returns the default measure value for the second third, and fourth fiscal quarters of fiscal year 2002.

```
SELECT LastPeriods(3,[Date].[Fiscal].[Fiscal Quarter].[Q4 FY 2002]) ON 0
FROM [Adventure Works]
```

##### Note

This example can also be written using the : (colon) operator:

`[Date].[Fiscal].[Fiscal Quarter].[Q4 FY 2002]: [Date].[Fiscal].[Fiscal Quarter].[Q2 FY 2002]`

The following example returns the default measure value for the first fiscal quarter of fiscal year 2002. Although the specified number of periods is three, only one can be returned because there are no earlier periods in the fiscal year.

```
SELECT LastPeriods
(3,[Date].[Fiscal].[Fiscal Quarter].[Q1 FY 2002]
) ON 0
FROM [Adventure Works]
```