Forum Discussion
jordancole0517
Helper I
Helper IPrior Year Sales Not Working with Summarize Function
Hello! I'm looking to create a table that shows each of our stores sales by week and year. I am having issues when using the summarize function, however. I'm sure I'm doing something obviosly wro...
lbendlin
Super User
Super UserYou will want to check out the "Year Over Year To Date" pattern for that. If you have a proper calendar table then you can use time intelligence functions like SAMEPERIODLASTYEAR combined with the appropriate "to date" filters.