Events
Sep 15, 6 AM - Sep 17, 3 PM
The best SQL community-led learning event. Sept 2025. Save €200 with code FABLEARN.
Get registeredThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by the Quarter level in the Time dimension.
Qtd( [ Member_Expression ] )
Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.
If a member expression is not specified, the default is the current member of the first hierarchy with a level of type Quarters in the first dimension of type Time in the measure group.
The Qtd function is a shortcut function for the PeriodsToDate (MDX) function whose level expression argument is set to Quarter. That is, Qtd(Member_Expression)
is functionally equivalent to PeriodsToDate(Quarter_Level_Expression, Member_Expression)
.
The following example returns the sum of the Measures.[Order Quantity]
member, aggregated over the first two months of the third quarter of calendar year 2003 that are contained in the Date
dimension, from the Adventure Works cube.
WITH MEMBER [Date].[Calendar].[First2MonthsSecondSemester2003] AS
Aggregate(
QTD([Date].[Calendar].[Month].[August 2003])
)
SELECT
[Date].[Calendar].[First2MonthsSecondSemester2003] ON COLUMNS,
[Product].[Category].Children ON ROWS
FROM
[Adventure Works]
WHERE
[Measures].[Order Quantity]
Events
Sep 15, 6 AM - Sep 17, 3 PM
The best SQL community-led learning event. Sept 2025. Save €200 with code FABLEARN.
Get registered