SAMEPERIODLASTYEAR

SAMEPERIODLASTYEAR is a DAX function that returns a set of dates from the previous year corresponding to the current selection.

Syntax

SAMEPERIODLASTYEAR( Dates )

Argument	Properties	Description
Dates		The name of a column containing dates or a one column table containing dates.

Return Values

A single-column table of date values.

Remarks

• The dates argument can be any of the following:

  • A reference to a date/time column,
  • A table expression that returns a single column of date/time values,
  • A Boolean expression that defines a single-column table of date/time values.

• Constraints on Boolean expressions are described in the topic, CALCULATE.

• The dates returned are the same as the dates returned by this equivalent formula: DATEADD(dates, -1, year)

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

The following sample formula creates a measure that calculates the previous year sales of Reseller sales.

= CALCULATE(SUM(ResellerSales_USD[SalesAmount_USD]), SAMEPERIODLASTYEAR(DateTime[DateKey]))

Related functions

Other functions related to SAMEPERIODLASTYEAR are:

• PREVIOUSDAY
• PREVIOUSMONTH
• PREVIOUSQUARTER
• PREVIOUSYEAR

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/sameperiodlastyear-function-dax