SAMEPERIODLASTYEAR() function not working

Hi Aditya_Vikki ,

 

I have tested it and it works. The DAX Guider you can refer. 

SAMEPERIODLASTYEAR function (DAX) - DAX | Microsoft Docs

 

Or you can try the equivalent formula:DATEADD(dates, -1, year)

 

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

 

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