TOTALYTD with SAMEPERIODLASTYEAR not working as expected

[sanimesa]

I have sales data for all of 2016 and up to September for 2017. I am trying to get the 2016 sales up to the last date in 2017.

YTD Sales = TOTALYTD(SUM('Sales History'[Sales Amount]), 'Date'[Date]) 

 -- this correctly sums up all of 2017

YTD Sales LY = CALCULATE ([YTD Sales], SAMEPERIODLASTYEAR('Date'[Date] )) 

-- expecting SUM('Sales History'[Sales Amount]) for 2016 up until September but returns sum of all rows for 2016. 

I am sure my understanding is incorrect somewhere, please help. 

[Interkoubess · Accepted solution]

Hi @sanimesa,

What about testing this following formulae (replace TOTALYTD with calculate):

YTD Sales = CALCULATE(SUM('Sales History'[Sales Amount]), DATESYTD('Date'[Date]))
 
YTD Sales LY = CALCULATE ([YTD Sales], SAMEPERIODLASTYEAR('Date'[Date] )) 

Thx

Ninter