NEXTYEAR
The dates of the year after the last date in the filter context (the year ending on 31 December, or on a date given).
Group: Time intelligence. Compatible with DAX.
Syntax
NEXTYEAR ( <dates> [, <year_end_date>] )| 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. |
year_end_date | Text optional | The year's last day as month and day, such as "6-30" for a year that ends on 30 June; when left out, 31 December. Not used with a calendar, whose own years count. |
Returns
Table. The dates the column holds in the year after the last date in the filter context.
Remarks
- The whole next year comes back, as far as the column reaches: from March 2025 on Sales[Month], January to October 2026, where the data ends.
- With a year end, the years are those that end on it: from March 2025 with "6-30", July 2025 to June 2026.
- 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
The next calendar year and the next season
EVALUATE
CALCULATETABLE (
ROW (
"Next year, liters", CALCULATE ( [Liters sold], NEXTYEAR ( Sales[Month] ) ),
"Its months", COUNTROWS ( NEXTYEAR ( Sales[Month] ) ),
"Next season, from", MINX ( NEXTYEAR ( Sales[Month], "6-30" ), Sales[Month] ),
"Next season, to", MAXX ( NEXTYEAR ( Sales[Month], "6-30" ), Sales[Month] )
),
Sales[Month] = DATE ( 2025, 3, 1 )
)| Next year, liters | Its months | Next season, from | Next season, to |
|---|---|---|---|
| 523302 | 10 | 2025-07-01 | 2026-06-01 |