Forum Discussion

knche1234's avatar
knche1234
Regular Visitor
9 years ago
Solved

Total Sales Last Year , Need Help!!

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?