Create a measure for sameperiodlastyear

Anonymous — Fri, 24 Apr 2020 20:30:25 GMT

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

Re: Create a measure for sameperiodlastyear

camargos88 — Fri, 24 Apr 2020 20:43:56 GMT

Hi Anonymous ,

Try this measure:

_LY =

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

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

Ricardo

topic Create a measure for sameperiodlastyear in DAX Commands and Tips

Create a measure for sameperiodlastyear

Re: Create a measure for sameperiodlastyear