<!-- https://learnsql.cpetoday.com/functions/dax/nextmonth -->
# NEXTMONTH

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

## 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
- dates: the date column of the Calendar table. Required.

## 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.

```dax
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.

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

## Things to watch
- NEXTMONTH needs data for future dates. If the schedule or budget stops at the current date, the result is blank.
- It returns the whole next month, so it does not change as the current month passes.
- It uses calendar months. For a fiscal month, filter on the fiscal columns.
- Keep forecast measures clearly labeled, so readers do not mix plan with actual.

## 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.
