Sameperiodlastyear

Think about it some more. last year same date will NOT be the same weekday.  Instead, subtract 364 to arrive at the same weekday.

Hi,

Thanks for the solution lbendlin  provided, and i want to provide some more information for user to refer to.

hello jorgensorensen , based on your description, if you want to return the same date for the last year, you can use edate() function.

e.g 

Measure = EDATE(MAX('Table'[Date]),-12)

Output

and you can refer to the following link about the function.

EDATE function (DAX) - DAX | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.