Sameperiodlastyear

[lbendlin · Accepted solution]

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

[v-xinruzhu-msft · Accepted solution]

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.

[lbendlin · Accepted solution]

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