Running Totals Without a Traditional Calendar Table
PowerPivot provides a host of great functions like DATESYTD, DATESMTD, DATESBETWEEN, etc. that are useful for calculating many things, including a running total.
But with the exception of DATESBETWEEN, I seldom get to use any of those "time intelligence" functions, for the simple reason that our clients almost never operate on a traditional calendar.
Read more...