Forum Discussion

scaast's avatar
scaast
Frequent Visitor
9 years ago
Solved

sameperiodlastyear to current date

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.  

Need Help
  • scaast's avatar
    scaast
    9 years ago

    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))
    ))

     

     

2 Replies

    • scaast's avatar
      scaast
      Frequent Visitor
      9 years ago

      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))
      ))