DAX - Calculate total for LY minus one day

[Anonymous]

I need a simple calculation that will give me the count of sales for prior year minus one day (today).

Can someone help?

[MauriceMecowe]

Measure = DATE(YEAR(NOW())-1,MONTH(NOW()), DAY(NOW()-1))

[Anonymous · Accepted solution]

Can you try this?

CALCULATE(SUM(Sales_Fact.Sales),DATEADD(Dates[Date]-1,-1,YEAR)

Thanks
Raj