This content has been marked as final.
Show 2 replies
-
1. Re: Compare month with average of previous year
Amit Narkar Jun 25, 2018 1:27 AM (in response to Andreas Kampianakis)1 of 1 people found this helpfulCreate a date parameter
1. Sales=
sum(if year([Order Date])= year([date parameter])
AND month([Order Date])=month([date parameter])
then [Sales]
end)
2. Avg Sales=
sum(if year([Order Date])= year([Date parameter])-1
then [Sales]
end)/12
-
2. Re: Compare month with average of previous year
Andreas Kampianakis Jun 25, 2018 4:05 AM (in response to Amit Narkar)Thanks, I was really stuck , and your solution seems so intuitive !
Have a good day!