Forum Discussion
Previous Week variance
Hi, I want to pull in the previous week into the table, so for example next to week thritheen i want to show week 12 and then do a variance on it. How would I pull in the previous week? T...
Im guessing it would be something like
calculate(sum(sales), dateadd(calenderdate)-date(weeknum(calenderdate)-7))
?