@Sahil
I found that’s how relative date filters work in Quick Sight in general. It’s not specific to Q. Take a look at this post:
Quick Sight includes the full period. Even though we’re still at the beginning of August, it includes the whole month of August. I think for most people this is not the desired behaviour, so we should have both options like I suggested in my post.