SAMEPERIODLASTYEAR Should not automatically go to the end of the month

[Paul_Schaerer]

Currently SAMEPERIODLASTYEAR automatically goes to the end of the month, so in reality it is not measuring the same period. Below is a fix that I am having to implement. Thankfully I QA'd my work and found the error otherwise I would be mis-reporting on the assumption that SAMEPERIODLASTYEAR is exactly the SAMEPERIODLASTYEAR.



DATESBETWEEN(REG000b[Actual End Date],
SAMEPERIODLASTYEAR(FIRSTDATE(DATESYTD(REG000b[Actual End Date], "31 March"))),
SAMEPERIODLASTYEAR(LASTDATE(DATESYTD(REG000b[Actual End Date], "31 March")))),

I don't think it would take much to build in the LASTDATE function into the SAMEPERIODLASTYEAR function?