Running Totals Without a Traditional Calendar Table

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

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...

Tags: dax, date, design

 

2007-2015 VidasSoft Systems Inc.