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 ti...
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
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