Implement advanced filter where date after given date but before current date

Hi,

I have my customer renewal data left joined with customer score data (score allocated based on many factors like installtion status, settings status etc.). Customer scores were allocated only since Aug 1 but renewal data goes about an year and half0 further back than that. I am trying to show renewal rate in correlation with score but the data in graph only makes sense for dates between Aug 1 and 1 day before current date. Where do i apply that date filter in powerbi service?