Downloads
DAXTime intelligence: shift and compareIntermediate

NEXTYEAR

Returns all the dates of the year after the year in the filter context.

Syntax
NEXTYEAR(<dates> [, <year_end_date>])

Returns: A table of dates.

What it does

NEXTYEAR returns every date in the year after the one in context. A measure built on it shows the whole of next year's figure, such as the annual budget for the coming year. Finance teams use it when they build the annual plan, when they compare the current year's forecast with next year's budget, and when they prepare the budget submission for a parent company.

Syntax and arguments

Example

A company with a June 30 year end is building its fiscal 2028 budget. In any month of fiscal 2027, the planning page shows the full budget for fiscal 2028, which runs from July 1, 2027 through June 30, 2028.

Budget Next Fiscal Year =
CALCULATE([Budget Revenue], NEXTYEAR('Calendar'[Date], "6/30"))

The measure gives the whole next fiscal year in each row, so the team can compare the annual figure with the year to date forecast for the current year.

Example: a second, different use

The next fiscal year budget for each product line, shown as a growth rate against the current year's forecast.

Budget Growth vs Forecast =
DIVIDE(
    CALCULATE([Budget Revenue], NEXTYEAR('Calendar'[Date], "6/30")) - [Forecast Revenue],
    [Forecast Revenue]
)

Things to watch

In business terms

NEXTYEAR supports the annual budget process, the next year plan that goes to the board or the lender, and the growth targets that a finance team sets for each business unit. It shows the next year's plan next to the current year's results.

Related functions

All DAX functions · View as Markdown · DAX fundamentals