Sunday, November 3, 2013

Age at January first each year

CREATE MEMBER CURRENTCUBE.[Measures].[Age jan1]
AS Datediff("yyyy",[Customer].[Birth Date].CurrentMember.Name, CDATE("01/01/"+ right([Date].[Calendar Year].CurrentMember.Member_value,4))),
VISIBLE = 1, DISPLAY_FOLDER = 'Ages' ;

Till Next Time

No comments: