Forum Discussion
Prior 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...
You 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.