NEXTMONTH

The dates of the month after the last date in the filter context.

Group: Time intelligence. Compatible with DAX.

Syntax

NEXTMONTH ( <dates> )

Parameter	Type	Description
`dates`	Dates	A column of dates of the model, such as `Sales[Month]`, or the name of a calendar defined in the model.

Returns

Table. The dates the column holds in the month after the last date in the filter context.

Remarks

The whole next month comes back, whatever part of the current month is selected; with a selection over several months, the month after the last.
Only dates the column holds come back: a date the move or the period lands on that the column lacks is left out, and when none is left the table is empty.
Given a column, it reads the dates visible in the current filter context; in a row context, such as ADDCOLUMNS, the row becomes a filter first, so each row sees its own dates.
Given a calendar instead of a column, it works on the calendar's own periods (fiscal years, retail months of four or five weeks, ISO weeks). A filter on a category the calendar does not define, such as a month on a calendar of weeks, can make the call an error.

Examples

Liters of the month before and the month after

EVALUATE
ADDCOLUMNS (
    DATESBETWEEN ( Sales[Month], DATE ( 2025, 2, 1 ), DATE ( 2025, 5, 1 ) ),
    "Liters", [Liters sold],
    "Previous month", CALCULATE ( [Liters sold], PREVIOUSMONTH ( Sales[Month] ) ),
    "Next month", CALCULATE ( [Liters sold], NEXTMONTH ( Sales[Month] ) )
)
ORDER BY Sales[Month]

Sales[Month]	Liters	Previous month	Next month
2025-02-01	44831	44635	43593
2025-03-01	43593	44831	44318
2025-04-01	44318	43593	49448
2025-05-01	49448	44318	59243

A whole month of business days

From Friday 30 January 2026, the next month is February's 20 business days.

EVALUATE
CALCULATETABLE (
    ROW (
        "Days", COUNTROWS ( NEXTMONTH ( Prices[Date] ) ),
        "From", MINX ( NEXTMONTH ( Prices[Date] ), Prices[Date] ),
        "To", MAXX ( NEXTMONTH ( Prices[Date] ), Prices[Date] )
    ),
    Prices[Date] = DATE ( 2026, 1, 30 )
)

Days	From	To
20	2026-02-02	2026-02-27

PREVIOUSMONTH, NEXTQUARTER, DATEADD, PARALLELPERIOD.

Last updated 3 November 2026 · OpenBI Studio 0.3.74