NEXTDAY
The day after the last date in the filter context.
Group: Time intelligence. Compatible with DAX.
Syntax
NEXTDAY ( <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 day after the last date in the filter context, when the column holds it.
Remarks
- The day is the calendar's next day, not the column's next date: on a column of business days, the day after a Friday is a Saturday the column lacks, and the result is empty, which shows as blank.
- 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. - With several dates in the filter context, it is the day after the last of them.
- 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
On business days
Friday 4 September has no next day in the column, Monday 7 September no previous day.
EVALUATE
ADDCOLUMNS (
DATESBETWEEN ( Prices[Date], DATE ( 2026, 9, 3 ), DATE ( 2026, 9, 8 ) ),
"Next day", NEXTDAY ( Prices[Date] ),
"Previous day", PREVIOUSDAY ( Prices[Date] )
)
ORDER BY Prices[Date]| Prices[Date] | Next day | Previous day |
|---|---|---|
| 2026-09-03 | 2026-09-04 | 2026-09-02 |
| 2026-09-04 | (blank) | 2026-09-03 |
| 2026-09-07 | 2026-09-08 | (blank) |
| 2026-09-08 | 2026-09-09 | 2026-09-07 |