how to compare relative day of month and day of week between two years

[Yaw]

Can anyone show me how to compare sales data relative date i.e same day of month and day of week between two years

[ekramer]

I would suggest adding a calculated value using the formula DATE(year, month, day) where the year is always today's year, and the month and the day are from your data. 

[Yaw]

I tried but couldn't work for me 

[Beginner]

If you are happy to use a "ScoreCard" you can set a custom default date range to show 'Today' and compare against a custom Comparison Date range of "Today minus 730 days (365 x 2)". Does this help?

[Yaw]

Thanks