<!-- https://learnsql.cpetoday.com/functions/dax/nextquarter -->
# NEXTQUARTER

Language: DAX
Category: Time intelligence: shift and compare
Syntax: NEXTQUARTER(<dates>)
Summary: Returns all the dates of the calendar quarter after the first date in the filter context.
Returns: A table of dates.
Level: Intermediate
Related: NEXTMONTH, NEXTYEAR, PREVIOUSQUARTER, DATEADD, CALCULATE

## What it does
NEXTQUARTER returns every date in the quarter after the one in context. A measure built on it shows the whole of the next quarter's figure. Finance teams use it for next quarter's budget, the forecast for the coming quarter and the planned debt or lease payments that fall in the next quarter.

## Syntax and arguments
- dates: the date column of the Calendar table. Required.

## Example
A planning team reviews the budget for the next quarter during the current quarter. In a view of Q3 2026, the measure shows the full budget for Q4 2026.

```dax
Budget Next Quarter = CALCULATE([Budget Revenue], NEXTQUARTER('Calendar'[Date]))
```

The budget row for Q3 shows the Q4 target, so the team can see the step up or down that the plan expects. The measure is useful as a planning check, not as a result.

## Example: a second, different use
The forecast for the next quarter, with the planned lease payments due in that quarter, for the cash plan.

```dax
Lease Payments Next Quarter =
CALCULATE(
    SUM('Lease_Schedule'[Payment]),
    NEXTQUARTER('Calendar'[Date])
)
```

## Things to watch
- NEXTQUARTER uses calendar quarters. A fiscal quarter needs a filter on the fiscal columns.
- The result is blank where no budget or schedule exists for the next quarter.
- The whole next quarter is returned, even if the view shows only part of the current quarter.
- Label forecast and budget measures clearly, so the next quarter is never mistaken for an actual.

## In business terms
NEXTQUARTER supports quarterly budget planning, the rolling forecast, the cash plan for the next quarter and the lease and debt schedules. It keeps the planning horizon visible in the same report as the actuals.
