数据模型

日期表作为维度。

新用户数

AARRR_NewUserCount = // new user count
CALCULATE( COUNTROWS( 'AARRR_User' ) , USERELATIONSHIP( 'Calendar'[CalendarDate] , 'AARRR_User'[ActiveDate] ) )

积累用户数 LTD

AARRR_CumulativeUserCount = // new users count of life-to-date
IF( MAX( 'AARRR_User'[ActiveDate] ) < MIN( 'Calendar'[CalendarDate] ) , BLANK() ,
    CALCULATE(
        COUNTROWS( 'AARRR_User' ) , 
        USERELATIONSHIP( 'Calendar'[CalendarDate] , 'AARRR_User'[ActiveDate] ) ,
        FILTER( ALL( 'Calendar' ) , 'Calendar'[CalendarDate] <= MAX( 'Calendar'[CalendarDate] ) )
    )
)