Looking for DAX formula to compare total services of a selected week(s) with last year same period. For example, I like to be able to compare total services (count) of service Week 1 January 2018 with Week 1 January of 2017. Week starts with first of the month + 7. So, week 1=1 thru 7, week 2 = 8 thru 14, week 3 = 15 thru 21, week 4 = 22 thru 28 and week 5 = the rest. I will use the week variable in filter along with service year and month.
I have looked at comparing current year or even current month with same period last year but figures don’t match with the data.