sumx with date range lookup

Hi I have an issue with my  report. I cannot share my actual data for privacy so I have created a mockup model to explain my issue I have spent a lot of time on it but it is behond my skills and i c...