The WTD function
returns a set that contains a particular member of the Time hierarchy
and all preceding members that are of the same level and are from
the same week. The WTD function is equivalent
to the PeriodsToDate function with a level of Time.Week specified.
Returns: A set.
Parameters
- MemberExpression
- Specifies the chronologically last member of the Time hierarchy
that is to be returned.
If you omit this parameter, the function uses Time.CurrentMember by default.
Description
Use the WTD function to return a set of members of the Time hierarchy from the same week, up to and including a particular member. For example, you might use the function to return the set of days in the week up to and including December 31, or the set of hours in the current week up to and including the current hour.
Example
Refer to the MTD, QTD, and YTD functions for examples of functions similar to WTD.
Related functions
The WTD, MTD, QTD, and YTD functions are equivalent to the PeriodsToDate function with a level specified for the LevelExpression parameter. WTD specifies Time.Week, MTD specifies Time.Month, and so on.