PREVIOUSWEEK
The dates of the week before the first date in the filter context; needs a calendar.
Part of the calendar-based time intelligence that Power BI added in 2025.
Group: Time intelligence. Compatible with DAX.
Syntax
PREVIOUSWEEK ( <calendar> )| Parameter | Type | Description |
|---|---|---|
calendar | Calendar | The name of a calendar defined in the model that has a week category. |
Returns
Table. The calendar's dates of the week before the first date in the filter context.
Remarks
- It takes a calendar only: a column of dates is an error. A calendar is defined in the model on a date table and tags its columns as year, quarter, month, week, date and the like; the week is whatever the calendar's week column says, ISO weeks from Monday or a retail week.
- The whole previous week comes back. With ISO weeks and Wednesday 13 March 2024 in the filter, it is 4 to 10 March.
- The result holds the calendar's rows with all its tagged columns, so it is meant as a filter:
CALCULATE ( MIN ( 'Date'[Date] ), ... )gives one date from it.
Examples
Without a calendar
The Example Brewery defines no calendar, so a date column is all it can offer, and the call fails.
EVALUATE
CALCULATETABLE ( PREVIOUSWEEK ( Prices[Date] ), Prices[Date] = DATE ( 2026, 9, 9 ) )Result: an error.