NEXTQUARTER DAX Function
The NEXTQUARTER function returns a table that contains a single column of all dates in the next quarter, based on the first date specified in the dates column, in the current context.
For example, if the first date in the dates column refers to June 10, 2009, this function returns all dates for the quarter July to September, 2009 i.e. from 1st July 2009 to 30th September 2009.
Quarters in a Year
DAX Syntax NEXTQUARTER(dates)
The parameter "dates" is a column containing dates.
Example: The following sample formula creates a measure that calculates the 'next quarter sales'.
DAX
Sum of next quarter income = CALCULATE(SUM(Sheet8[Annual Income]), NEXTQUARTER('Sheet8'[Year]))
This value is sum of the all the dates from 1st Oct 2005 to 31st Dec 2005. We can see that the next quarter starts from 1st of October.
