Forum Discussion
jpereztang
Helper I
Helper IWeekday 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...
vapid128
Solution Specialist
Solution SpecialistYOUR 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)
vapid128Solution Specialist
Solution SpecialistAND 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)