Analysis Services
PeriodsToDate
Returns a set of periods (members) from a specified level starting with the first period and ending with a specified member.
Syntax
PeriodsToDate([«Level»[, «Member»]])
Remarks
Within the scope of «Level», this function returns the set of periods on the level of «Member», starting with the first period and ending with «Member». If no level or member is specified, the «Member» value is Time.CurrentMember and «Level» is the parent level of Time.CurrentMember. If a level is specified, «Member» is dimension.CurrentMember, where dimension is the dimension of «Level».
Example
The following table lists the different ways you can use PeriodsToDate.
| Expression | Returns |
|---|---|
|
The set of days from the beginning of Quarter3. |
|
The set {January, February, March}. |
|
The set of members from the beginning of the year that is the ancestor of Time.CurrentMember, through Time.CurrentMember. |
|
The set of members from the beginning of the level containing the period of Time.CurrentMember to Time.CurrentMember. All the returned members are at the same level as Time.CurrentMember. |
PeriodsToDate(level, member) is the same as TopCount(Descendants(Ancestor(member, level), member.Level), 1):member