Cumulative total for period other than calendar year

[RichardRayJH]

I've got a measure with this formula:

CALCULATE([Net Amount],DATESYTD('Calendar-DC'[DateDate]))

That's fine for a standard calendar year, but the period I need is from 11/28/2013 to the current date in 2014 (or some other date range, always different from the calendar year). I thought I could do something with DATESBETWEEN, but I think I'm missing something. Any pointers?

 

[elgallo509]

I may not understand the end-goal, but could you add two cells and make them your variables? For example, in A1, you enter your start date. In A2 you enter your end date. Then you build your formula around those two dates and you can change them, as needed.

 

[RichardRayJH]

That's not quite it. I'm looking for the PowerPivot DatesYTD function expressed using lower lever functions so that I can get the equivalent results for a date range other than the YTD for the current year.