Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Returns whether a specified member is an ancestor of another specified member.
IsAncestor(Member_Expression1, Member_Expression2)
Member_Expression1
A valid Multidimensional Expressions (MDX) expression that returns a member.
Member_Expression2
A valid Multidimensional Expressions (MDX) expression that returns a member.
The IsAncestor function returns true if the first member specified is an ancestor of the second member specified. Otherwise, the function returns false.
The following example returns true if [Date].[Fiscal].CurrentMember is an ancestor of January 2003:
WITH MEMBER MEASURES.ISANCESTORDEMO AS
IsAncestor([Date].[Fiscal].CurrentMember, [Date].[Fiscal].[Month].&[2003]&[1])
SELECT MEASURES.ISANCESTORDEMO ON 0,
[Date].[Fiscal].MEMBERS ON 1
FROM [Adventure Works]
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today