Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-26-2013, 05:53 AM
Paul-NYS Paul-NYS is offline Cumulative numbers/percents using DAX Windows XP Cumulative numbers/percents using DAX Office 2007
Novice
Cumulative numbers/percents using DAX
 
Join Date: Jun 2011
Posts: 11
Paul-NYS is on a distinguished road
Default Cumulative numbers/percents using DAX

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
File Type: xlsx s1Issue.xlsx (16.9 KB, 7 views)
Reply With Quote
  #2  
Old 10-01-2013, 08:57 AM
Catalin.B Catalin.B is offline Cumulative numbers/percents using DAX Windows Vista Cumulative numbers/percents using DAX Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

Hi, have you tried using the Running Total calculation?
Look at value field settings for Count of Exit Month , Click on tab: Show values as: "Running Total in" , and in Base field, select ExitMonthCategory
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I refer to page numbers, when the numbers change as I prepare the document? StevenD Word 5 11-29-2012 12:52 AM
Numbers on the pages Groucho Word 2 02-23-2012 02:14 AM
Cumulative numbers/percents using DAX Page Numbers Not Matching Chapter Numbers gracie5290 Word 1 02-02-2012 11:41 PM
Cumulative numbers/percents using DAX Numbers rdcrags Word 4 11-13-2011 11:11 AM
Numbers Missing-HELP! ofriendasu Word 0 07-12-2010 03:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft