PowerPivot Use Case: Getting the active products between a date range using DAX

I have been getting this question a few times in the last week, e.g. in my ask a questions page here, on how we can get the number of active products between two time intervals in Excel. Lets answer the question on my ask a questions page in todays blog post.
The question was: