How to count rows upto user selected date?

Hi all, I have a table named SALES which looks like the following:   I also have a date dimension table named dimDate that groups the dates by Year and by Quarter, as follows (I have shorten...