Create a measure for sameperiodlastyear

[Anonymous]

Hello, is there a way to create a measure for sameperiodlastyear so I can drag it into a dashboard? If I want to create a column in a dashboard with today's date, I can simply create a measured called Today and the DAX formula is Today = today(); however, I can't seem to do that with sameperiodlastyear. 

This is what I want in my dashboard, with Date available in the data. 

Date	Sameperiodlastyear
1/1/2020	1/1/2019
1/8/2020	1/8/2019
1/15/2020	1/15/2019
1/22/2020	1/22/2019
1/29/2020	1/29/2019
2/5/2020	2/5/2019

[camargos88 · Accepted solution]

Hi @Anonymous ,

Try this measure:

_LY =

VAR _date = MAX('Table'[Date])

RETURN DATE(YEAR(_date) - 1; MONTH(_date); DAY(_date))

Ricardo