Downloads
DAXTime intelligence: shift and compareIntermediate

NEXTMONTH

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

Syntax
NEXTMONTH(<dates>)

Returns: A table of dates.

What it does

NEXTMONTH returns every date in the month after the one in context. A measure built on it shows the total for the whole following month. Finance teams use it for the next month's debt service, the budget for the next month, and the scheduled payments that will fall due in the coming month.

Syntax and arguments

Example

A treasury team wants the total debt payments due in the next month, shown on the cash planning page. The debt schedule lists each payment with its payment date.

Debt Service Next Month =
CALCULATE(
    SUM('Debt_Schedule'[Payment]),
    NEXTMONTH('Calendar'[Date])
)

In a row for October 2026, the measure adds up every scheduled payment dated in November 2026. The figure is set by the schedule, not by actual cash, so it is a plan.

Example: a second, different use

The budget for the next month, placed next to the current month's actual figure in a monthly planning table.

Budget Next Month = CALCULATE([Budget Expenses], NEXTMONTH('Calendar'[Date]))

Things to watch

In business terms

NEXTMONTH supports debt service planning, next month's budget checks, cash planning for the coming month, and the rolling forecast. It is the simplest way to see what the next month holds in the schedule.

Related functions

All DAX functions · View as Markdown · DAX fundamentals