periodstodate Function

Function:

periodstodate

Syntax:

Sum(periodstodate (<Time Dimension Name>.<Time Level Name>), [Measures].[<measure name>])

Description:

This function enables you to make cumulated totals according to the Time Level of a Time Dimension for a specified measure.

Example: here the « Time Dimension Name » dimension is the DATE.[by Month] dimension, the « Time Level Name » level is the « Quarters » level and the « measure name » measure is the QTY field (Quantity). We get the cumulated sum of the quantities by quarter.

Sum(periodstodate(DATE.[by Month].Quarters), [Measures].[QTY])

This enables you to make a cumulated sum from the beginning of the specified level up to the current period.

For example, a cumulated sum from the beginning of the year, or the beginning of the quarter, or the beginning of the year etc.