12 Months rolling average

Hello Community,   I hav a table (Case) with : 1. Case ID 2. Casedatevalue which contains date and is of date type   I want to have count of case id by month and also rolling average for 12 mon...