title: Computing a "sprint" based on the current date
body: <p>I'm building a PowerPivot/AS data model and I need to convert a date to the appropriate sprint.  A sprint is defined as a span of dates (i.e. Sprint N = date range from Date A to Date B).  Ideally, I can add this new value as a field in my Date hierarchy.  How can I write a DAX formula that will take a date and output the appropriate sprint?</p>
  
  <p>To make things more complicated, in an ideal world different teams can have different dates for a sprint so it would be nice to take the teamId as input and use that to help compute the appropriate sprint name for a given date.  NOTE I do have the team/sprint name/sprint start &amp; end dates available for querying</p>