ToDateTotalExamples.sql

WITH cteRevenueDays(Orders, StoreDate, Revenue) AS (
	SELECT COUNT(SalesOrderID) AS Orders
		,CAST(OrderDate AS DATE) as [StoreDate]
		,SUM(SubTotal) AS Revenue
	FROM [AdventureWorks2019].[Sales].[SalesOrderHeader]
	WHERE DATEPART(YEAR, CAST(OrderDate as DATE)) = 2011
		AND DATEPART(MONTH, CAST(OrderDate as DATE)) = 7
	GROUP BY CAST(OrderDate as DATE)
) SELECT 
	StoreDate
	,DATEPART(WEEK, StoreDate) AS [StoreWeek]
	,Orders
	,ROUND(Revenue, 2)
	,ROUND(SUM(Revenue) OVER(PARTITION BY DATEPART(WEEK, StoreDate) ORDER BY StoreDate),2) AS WeekToDateRevenue
	,ROUND(SUM(Revenue) OVER(ORDER BY StoreDate),2) AS MonthToDateRevenue
FROM cteRevenueDays;