Leap year - year over year by month issue

[dbowman]

Hello,

We are trying to do a year over year comparison by month. Every year works great except for when the previous year was a leap year. Please see below for the behavior. We are using the SAMEPEROIDLASTYEAR expression.

Any help is appreciated and thank you!

Previous Year - Completed = CALCULATE((SUM('Month'[Issued Count])+sum('Month'[Canceled Count])+sum('Month'[Declined Count])),SAMEPERIODLASTYEAR('Month'[Month End Date]),ALL('Month'))

[v-yuta-msft]

@dbowman ,

You may try PREVIOUSYEAR() instead. Please refer to: https://docs.microsoft.com/en-us/dax/previousyear-function-dax. However, if this issue persists, could you share some sample data and clarify more details about your expected result?

Community Support Team _ Jimmy Tao

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

[dbowman]

Hi @v-yuta-msft,

Thanks for your response. This is not working either. And we also have another issue now.

Current year count is a value from the month query.

Previous Year - Received = CALCULATE(SUM('Month'[Month Received Count]),SAMEPERIODLASTYEAR('Month'[Month End Date]),ALL('Month'))

Year in chaart is a value on the month query.

Month end date is a value on the month query.

Year slicer is a value from teh dates query, related to the month query.

Issue 1. Previous year being a leap year, breaking the month of February visual.

Issue 2. Previous year measure not showing at all on visual unless more than one year selected in slicer.

Thanks,

David