Total Sales Last Year , Need Help!!

[knche1234]

Hi!

Need help with the following scenario: 

I need to calculate the count of Last Year YTD Sales: 

LY YTD Sales = TOTALYTD([YTD Sales],SAMEPERIODLASTYEAR('BASE BBI AS400'[Fecha Activación].[Date])) 

Apparently it is showing the amount of all sales in 2016 and not the value YTD I am looking for, it shows all 2016 sales. 

I used the following formula to calculate YTD sales: 

YTD Sales = TOTALYTD(COUNTAX('BASE BBI AS400','BASE BBI AS400'[Anexo]),'BASE BBI AS400'[Fecha Activación].[Date])

This formula shows the exact amount for sales starting 01/Jan/2017. 

How can I fix the formula to show the total last year from same period on this year? 

[Phil_Seamark · Accepted solution]

Have a bit of a read through this article.

https://www.kasperonbi.com/get-the-ytd-of-same-period-last-year-using-dax/

and see if that helps any,