Dax formula for calculating last years sales. HELP!

[shophoney]

Hi I need assistance on a DAX formula. I would like to total last years sales to add back to my OH as of today.

This is what I have for calculating last years sales as of today. But I want the start date to be able to move as the month advances.

UNITS SOLD LAST YEAR:=CALCULATE('tblInvSkuMaster'[SALES TOTAL UNITS SOLD],DATESBETWEEN(dCalendar[dates],date(2016,5,26),TODAY()))

Thanks

 

[gazpage]

https://msdn.microsoft.com/en-us/library/ee634972.aspx

Or, in Power BI desktop, enable the quick measures preview and generate a measure from there. Gives you the dax code