Downloads
DAXTime intelligence: shift and compareIntermediate

PREVIOUSYEAR

Returns all the dates of the year before the year in the filter context.

Syntax
PREVIOUSYEAR(<dates> [, <year_end_date>])

Returns: A table of dates.

What it does

PREVIOUSYEAR returns every date in the year before the year in context. A measure built on it shows the whole of last year's figure, whichever month of the current year is visible. Finance teams use it for the full prior year benchmark in an annual report, for last fiscal year's results in a budget, and for the comparison that the board sees at the start of the year.

Syntax and arguments

Example

A company with a June 30 year end wants the full prior fiscal year revenue as a benchmark. In any month of fiscal 2027, the measure returns all of fiscal 2026, which runs from July 1, 2025 through June 30, 2026.

Revenue Prior Fiscal Year =
CALCULATE([Total Revenue], PREVIOUSYEAR('Calendar'[Date], "6/30"))

The figure stays the same across the months of fiscal 2027, because it is always the full prior year. That is the reason to use it for a benchmark instead of a year to date comparison.

Example: a second, different use

A calendar year budget review. The prior year total appears on each row of the budget table, so the team can see last year's full result next to this year's budget.

Revenue Prior Calendar Year = CALCULATE([Total Revenue], PREVIOUSYEAR('Calendar'[Date]))

Things to watch

In business terms

PREVIOUSYEAR gives the full prior year benchmark used in annual reports, budget reviews and board packs. It answers "how did last year end?" as a fixed number, which does not change during the year.

Related functions

All DAX functions · View as Markdown · DAX fundamentals