NEXTQUARTER
The dates of the quarter after the last date in the filter context.
Group: Time intelligence. Compatible with DAX.
Syntax
NEXTQUARTER ( <dates> )| 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. |
Returns
Table. The dates the column holds in the quarter after the last date in the filter context.
Remarks
- The whole next quarter comes back, whichever month of the current one is selected.
- 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
Liters of the quarter before and after
March is the last month of the first quarter, so its next quarter starts in April; April's is July to September.
EVALUATE
ADDCOLUMNS (
DATESBETWEEN ( Sales[Month], DATE ( 2025, 3, 1 ), DATE ( 2025, 5, 1 ) ),
"Liters", [Liters sold],
"Previous quarter", CALCULATE ( [Liters sold], PREVIOUSQUARTER ( Sales[Month] ) ),
"Next quarter", CALCULATE ( [Liters sold], NEXTQUARTER ( Sales[Month] ) )
)
ORDER BY Sales[Month]| Sales[Month] | Liters | Previous quarter | Next quarter |
|---|---|---|---|
| 2025-03-01 | 43593 | 140142 | 153009 |
| 2025-04-01 | 44318 | 133059 | 173446 |
| 2025-05-01 | 49448 | 133059 | 173446 |