Hi,
If you want to include other columns with month_name and value to be sum up, then try this:
select orderid, custid, orderdate, val, DateName(month, orderdate) as [Month],
sum(val) OVER(partition by datename(month, orderdate) order by month(orderdate)) as [MonthTotal]
from Sales.OrderValues
order by month(orderdate), orderid;