You need a proper date column but the in absence of that, here is an easy way in PQ.
Start:
Add column, extract, first 3
Group by, sum and all:
Result
Then expand: