Returns a set of dates in the current selection from the previous year.
The name of a column containing dates or a one column table containing dates.
The corresponding dates in the previous year.
The dates argument can be any of the following:
- A reference to a date/time column. Only in this case a context transition applies because the <Dates> column reference is replaced by
- 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.
If the number specified for NumberOfIntervals is positive, the dates in dates are moved forward in time; if the number is negative, the dates in dates are shifted back in time.
The result table includes only dates that exist in the dates column.
Internally SAMEPERIODLASTYEAR corresponds to the following call of DATEADD:
DATEADD ( <Dates>, -1, YEAR )
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/sameperiodlastyear-function-dax