Forum Discussion

waterphil's avatar
waterphil
Regular Visitor
7 years ago
Solved

Customer Retention from previous period

I would really appreciate some help with a problem I have very frustratingly failed to solve

 

I have a file that contains a number of customers per period. Some buy just once, some buy multiple times.

 

I want to know how many customers remain in the subsequent period

 

ex. 

Period 1 = 24 customers

Period 2 = 3 of 24 customers

 

i want to figure out how to get 3 in period 2

 

 

Show and Tell
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi waterphil,

     

    Then update the measure as below.

     

    Measure = CALCULATE(DISTINCTCOUNT(vw_busdev_report_revised[Name]),FILTER(vw_busdev_report_revised,[Measure 2]=1))
     
    Regards,
    Frank

13 Replies

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hello waterphil,

     

    You are a new member and i can say that this post doesnt help at all to understand your issue.

     

    Could you please provide us with some more information, visuals or even a sample dataset so as to understand your problem better?

    • waterphil's avatar
      waterphil
      Regular Visitor
      7 years ago
      Period No RecruitsNew Distributors%# Distributors from previous Period
      110039918847 % 
      28953130357 % 
      39649320942 % 
      49036723263 % 
      58936916344 % 
      68532417755 % 
      77551220039 % 
      88829211238 % 
      99229614449 % 
      109330614949 % 
      118919911859 % 
      12103671928 % 

       

      ex. out of 188 new distributors in period 1

      i want to know how many distributors sell again in period 2

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi waterphil,

     

    To create a measure as below. If it doesn't meet your requirement, kindly share your excepted result to me.

     

    Distributors from previous Period = var No = MAX(Table1[Period No])
var per = CALCULATE(SUM(Table1[Recruits]),FILTER(ALL(Table1),Table1[Period No]=No-1))
return
IF(ISBLANK(per),BLANK(),per-CALCULATE(SUM(Table1[New Distributors])))

    For more details, please check the pbix as attached.

     

    Regards,

    Frank

    • waterphil's avatar
      waterphil
      Regular Visitor
      7 years ago

      Hi Frank,

       

      I think i have to define each column

       

      Recruits - are not yet distributors until they sell and converted to new distributors

      New Distributors - i was able to get the new distributors coming from our recruits

       

      I want to know how many new distributors will perform again on the next period

       

      out of 399 recruits, we were able to convert 188 new distributors in period 1

      now, im interested to know out of 188 new distributors how many distributors will perform again on Period 2

       

       

       

    • waterphil's avatar
      waterphil
      Regular Visitor
      7 years ago

       Hi Frank,

       

      i think i have to define each column

       

      recuits - are not yet distributors 

      new distributors - are distributors coming from recruits who do their first sale

       

      i want to how many new distributors will perform again on the next period

       

      out of 399 recruits in Period 1 we were able to convert 188 new distributors

      now, im interested to know out of 188 new distributors in Period 1 how many will stay/sell again on Period 2

       

      Thanks!

      • waterphil's avatar
        waterphil
        Regular Visitor
        7 years ago

        here's the file

         

        this is the result I need - out of 5 new customers in P1 - 4 customers sell again in P2

        PeriodNewOldTotal CustomersResult
        1513184
        2111120
        33690
        Total918224