Hi
I have a data set that I load into Excel 2010's Powerpivot window and then pivot over it in Excel. For pivoting, I have been using DAX functions to create various aggregations by creating Measures within the pivot table.

However, I do not know how to create a cumulative numbers using DAX functions. I have a column for 'exit month category' that contains a value (6, 12, 18, 24, 30...) that represents the month (in six month increments) a child exited from the court system. I have a bar chart that displays the exit month category on the X-axis.

However, using DAX or some other Excel formula, does anyone know how I can get the record counts to aggregate as they move down the X-axis from left to right?

Attached is an example that does not use Powerpivot, but uses regular pivot tables instead.

Paul

Attached Files

s1Issue.xlsx (16.9 KB, 9 views)