sameperiodlastyear to current date

[scaast]

I'm trying to compare call volume YTD 2017 to call volume from 2016 for the same period (current date).  For example, today (2/16)...I'd like to compare call volume 1/1/2017-2/16/2017 to call volume from 1/1/2016-2/16/2016.  I have a calculated measure for YTD Calls Handled using the following formula:

YTD Calls Handled = TOTALYTD(SUM(dimVendorMetrics[Answered Calls]),dimDate[Date])

I then used the below formula to calculate 2016 YTD call volume, but it returns a value for the entire year of 2016.  How do I get the formula to calculate 2016 volume through the same date range of YTD 2017?

LY YTD Calls Handled = CALCULATE([YTD Calls Handled],SAMEPERIODLASTYEAR(dimDate[Date]))

Thank you for your help.  

[v-shex-msft]

Hi @scaast,

You can take a look at below link which has the same requirement:

Total Sales Last Year , Need Help!!

Regard,

Xiaoxin Sheng

[scaast · Accepted solution]

Thank you!  I edited the formula to provide previous YTD totals by day and it worked perfectly.

=CALCULATE(sum(dimCallMetrics[Answered Calls]),
DATESBETWEEN(dimDate[Date],
FIRSTDATE(DATEADD(dimDate[Date],-365,DAY)),
LASTDATE(DATEADD(dimCallMetrics[Date],-365,DAY))
))