SSRS How to create Date Frequency Grouping using Matrix

Question

Hi how can I create a date frequency such as Prior Week, Week to Date, Previous Month, Month to Date, Previous Quarter, Quarter to Date, Prior Year, Year to date using tablix Matrix? I was able to create a tablix matrix using Row_date (mm/dd/yyyy) and it's working as designed. I'm trying to figure out how to create a date frequency as mentioned above. Is it best to create the date grouping in SQL or is there a date calculation expression for this? Please advise. thanks.