Ytd

Analysis Services

Analysis Services

Ytd

Returns a set of members from the Year level in a Time dimension starting with the first period and ending with a specified member.

Syntax

Ytd([«Member»])

Remarks

The Ytd function is a shortcut function to the PeriodsToDate function that defines that function's «Level» argument to be Year. If no member is specified, the default is Time.CurrentMember.

Ytd(«Member») is equivalent to PeriodsToDate(Year, «Member»).

Example

The following example returns the set of members from the beginning of the year from the ancestor of Time.CurrentMember through Time.CurrentMember:

Ytd()
 

See Also

PeriodsToDate