Forum Discussion
Weekday Last Year Comparison
Hi everybody ! I have a requeriment that i don't know how to achieve. Question is simple, how can I compare this year sales with exactly the same weekday sales of last year. take for instance, To...
YOUR DATE LIKE THIS TABLE:
create weeknum and year colnum
and
SUMMARIZE(weeknum,year,"total sales", sum(sales))
last year = lookupvalue([total sales],[weeknum],[weeknum],[year],[year]-1)
AND question about your weeknum.
It is depends on how you want to read your week.
You week is from Monday to Sunday.
if you feel the week number may be some problem.
You can try make 01/01 - 01/07 of each year to week number 1, and 08 - 14 to week number 2.
weeknum = int(([date] - DATE(year([date],1,1)+1)/7)