Downloads
DAXTime intelligence: shift and compareIntermediate

NEXTQUARTER

Returns all the dates of the calendar quarter after the first date in the filter context.

Syntax
NEXTQUARTER(<dates>)

Returns: A table of dates.

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

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.

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.

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

Things to watch

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.

Related functions

All DAX functions · View as Markdown · DAX fundamentals