Show the sum of sales for the last 3 days based on date selection

A quick post today that came from one of the readers on the ask a question page: Let's say we have a dates table and fact table linked by a field called DatesID. The dates table has one field called DatesID and the fact table has two fields (DatesID and Quantity) as follows: