topic Re: SAMEPERIODLAST YEAR doesnt account for February Leap year in DAX Commands and Tips

SAMEPERIODLAST YEAR doesnt account for February Leap year

Miro — Wed, 25 Jan 2023 00:22:11 GMT

I have noticed that when doing Last Year Calculation, Sameperiod Last Year shows inconsistencies for February when there was a leap year either current/selected or it was a previous one.
Any recommendations to tackle the issue?

Re: SAMEPERIODLAST YEAR doesnt account for February Leap year

olgad — Wed, 25 Jan 2023 00:25:21 GMT

Hi there,
I had a similar issue, DATEADD worked well to solve this.
Try

LY = Calculate([Sales], DATEADD('Date'[Date], -1,YEAR))