NEXTYEAR
Returns all the dates of the year after the year in the filter context.
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
- dates: the date column of the Calendar table. Required.
- year_end_date: the fiscal year end as text, such as "6/30". Optional. Leave it out for a calendar year.
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
- The result is blank where no budget exists for the next year. Build the budget for every year in the Calendar before you rely on the figure.
- NEXTYEAR returns the whole year, not the part that has passed. It is a planning view.
- The fiscal year end must match the company's year end.
- Keep forecasts and budgets labeled, so they are not mistaken for actuals.
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.