skip to Main Content

Total Projected Customers:= [Continuing Customers]+[Customers Acquired] Customers Acquired:= CALCULATE(SUM(Incoming[New Customers]), FILTER(Incoming, Incoming[Year]=MAX(Years[Year]))) Continuing Customers:= SUMX(FILTER(Incoming, Incoming[Year]<MAX(Years[Year])), PRODUCTX(FILTER(Retention, Retention[Year After Being Acquired] <= MAX(Years[Year])-Incoming[Year] ), Retention[Retention Rate] ) *Incoming[New Customers])