Forum Discussion
Leap Year & Same Period Last Year Issue
I would like to do a comparison for sales current year and last year. However, 29/2/24 last year sales returned to 28/2/23.
29/2/24 LY sales suppose to return as 0.
My measure is
Sales LY = CALCULATE([Sales],SAMEPERIODLASTYEAR(dim_date[Date]))
Is there a way to show 0 on 29/2/24 Last year sales?
Best Regards,
Sosot
1 Reply
- lbendlin
Super User
For a true "Same Period Last Year" calculation subtract 364 days. That will work in all years, including leap years, and will get you closer to a "like for like" comparison.
