Forum Discussion
YOY by Weekending date
Hi, I am struggling to figure out how to create a YOY based off weekending date. I 3 tables 2018 revenue, 2019 revenue, and a dates table. I have calculated the weekending dates in my dates table...
If you have a "week of year" number in your dates table, you could do something like this:
Revenue YoY =
var __WeekOfYear = MAX('Date'[WeekOfYear])
var __ThisYearRevenue = CALCULATE(SUM('2019 Revenue'[Revenue])
var __LastYearRevenue = CALCULATE(SUM('2018 Revenue'[Revenue])
return __ThisYearRevenue - __LastYearRevenue Hope this helps,
Nathan