數(shù)據(jù)模型

日期表作為維度。

新用戶數(shù)

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

積累用戶數(shù) 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] ) )
    )
)