PREVIOUSQUARTER
The dates of the quarter before the first date in the filter context.
Group: Time intelligence. Compatible with DAX.
Syntax
PREVIOUSQUARTER ( <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 before the first date in the filter context.
Remarks
- The whole previous 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
The months of the quarter before
From March 2025, the quarter before is October to December 2024.
EVALUATE
CALCULATETABLE (
PREVIOUSQUARTER ( Sales[Month] ),
Sales[Month] = DATE ( 2025, 3, 1 )
)
ORDER BY Sales[Month]| Sales[Month] |
|---|
| 2024-10-01 |
| 2024-11-01 |
| 2024-12-01 |
Related functions
NEXTQUARTER, PREVIOUSMONTH, PREVIOUSYEAR, OPENINGBALANCEQUARTER.