ENDOFQUARTER
Gives the column's final date in the quarter of the filter context.
Group: Time intelligence. Compatible with DAX.
Syntax
ENDOFQUARTER ( <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 quarter's last date that the column holds, as a table of one row.
Remarks
- The quarter is the calendar quarter of the last date in the filter context; its last date is the last one the column has in it. On Sales[Month], whose dates are first days, the second quarter ends on 1 June.
- The table of one row can be used as a value; with no date in the context, it is blank.
- 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
The quarter's last business day
EVALUATE
SUMMARIZECOLUMNS (
Prices[Month],
FILTER ( VALUES ( Prices[Month] ), Prices[Month] >= DATE ( 2026, 3, 1 ) && Prices[Month] <= DATE ( 2026, 4, 1 ) ),
"End of quarter", ENDOFQUARTER ( Prices[Date] )
)
ORDER BY Prices[Month]| Prices[Month] | End of quarter |
|---|---|
| 2026-03-01 | 2026-03-31 |
| 2026-04-01 | 2026-06-30 |
On a column of first days
EVALUATE
CALCULATETABLE (
ROW ( "End of quarter", ENDOFQUARTER ( Sales[Month] ) ),
Sales[Month] = DATE ( 2025, 5, 1 )
)| End of quarter |
|---|
| 2025-06-01 |
Related functions
STARTOFQUARTER, ENDOFMONTH, ENDOFYEAR, CLOSINGBALANCEQUARTER.