Creating a Cumulative Measure

Creating a cumulative measure in BI Office can be accomplished by creating a custom measure with a very simple MDX code.

In this example, I would like to replace the measure Sales in the bellow grid with a cumulative measure based on Sales called Cumulative Sales:


To create the cumulative measure, I've created a new custom measure with the bellow MDX code:

{NULL:[Date].[Month Dates].CURRENTMEMBER},[Measures].[Sales]

*[Date].[Month Dates] - Needs to be replaced with the Hierarchy name.
*[Measures].[Sales] - Needs to be replaced with the measure you would like to accumulate


After creating the cumulative measure I've placed it on Rows instead of Sales and here is the result:


Please see attached screenshot for more information


Cumulative measure.jpg (quick view)

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like1 Follow
  • 5 yrs agoLast active
  • 890Views
  • 1 Following