SAMEPERIODLASTYEAR DAX Function (Time Intelligence) Context Transition
Returns a set of dates in the current selection from the previous year.
Syntax
SAMEPERIODLASTYEAR ( <Dates> )
| Parameter | Attributes | Description |
|---|---|---|
| Dates |
The name of a column containing dates or a one column table containing dates. |
Return values
Table A table with a single column.
The corresponding dates in the previous year.
Remarks
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
- CALCULATETABLE ( DISTINCT ( <Dates> ) )
- 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.
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 )
Related functions
Other related functions are:
Last update: Feb 6, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Jes Hansen
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/sameperiodlastyear-function-dax