Get values within a Start and End date using PowerPivot DAX

Again a interesting question on my ask a questions page, keep them coming :)

Luke had a question where he wanted to get a date based calculation:

I have a table of people and a table of project assignments. The assignments have a person, start date, end date and number of hours per week. I want to create a pivot that has the date as columns and people as rows, with the total number of assigned hours as values.