NEXTYEAR DAX Function

The NEXTYEAR time-intelligence function returns a table that contains a single column of all dates in the next year, based on the first date in the dates column, in the current context.

For example, if the first date in the dates column refers to the year 7 Aug 2007, this function returns all dates for the year 2008 i.e. from 1st Jan 2008 to 31st Dec 2008.

DAX Syntax NEXTYEAR(dates[,year_end_date])

The function has the following parameters:
• dates: A column containing dates.
• year_end_date (optional): A literal string with a date that defines the year-end date. The default is December 31. The year portion of the date is ignored.

Example: The following sample formula creates a measure that calculates the next year income.

DAX

Sum of next year income = CALCULATE(SUM(Sheet8[Annual Income]), NEXTYEAR('Sheet8'[Year]))
NEXTYEAR dax function

The value comes from the sum of all the Annual Income column values of dates from 1st Jan 2006 to 31st Dec 2006.

Previous Next