Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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))
))
Hi @scaast,
You can take a look at below link which has the same requirement:
Total Sales Last Year , Need Help!!
Regard,
Xiaoxin Sheng
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))
))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |