Forum Discussion

carolinefer's avatar
carolinefer
Icon for Helper I rankHelper I
4 years ago
Solved

Customer reactivation formula not working

Hello All,    I have a table with multiple measures related to churn but for some reason the Reactivated customer keeps giving me blank results. The formulas are all based on the same logic.  Rea...
Need Help
  • carolinefer's avatar
    carolinefer
    4 years ago

    Hi, I was able to find my error. it was related to the days since purchase. I was using Min date but I should have used the Data that the transactions happened. 

carolinefer's avatar
carolinefer
Icon for Helper I rankHelper I
4 years ago

I would love to be able to share the workbook bu the sensitive info is everywhere so I am unable to remove those fields. However, what I have notice is that it could be related to the days since last purchase. Because when I put all together, it is blank. would that be the reason? 

Days since last purchase = DATEDIFF([MIn date],[Max date], MONTH)
MIn date =
VAR CurrentName = SELECTEDVALUE(TotalBilled[customer_id])
RETURN
MINX(
FILTER(TotalBilled,TotalBilled[customer_id]=CurrentName),
TotalBilled[Date])
Max date =
VAR CurrentName = SELECTEDVALUE(TotalBilled[customer_id])
RETURN
MAXX(
FILTER(TotalBilled,TotalBilled[customer_id]=CurrentName),
TotalBilled[Date])
Thanks for taking your time to check that for me. 🙂 
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi carolinefer ,

    You can update the formula of measure [MIn date] and [Max date] as below and check whether you can get the expected result.

    MIn date =
    VAR CurrentName =
        SELECTEDVALUE ( TotalBilled[customer_id] )
    RETURN
        MINX (
            FILTER ( ALLSELECTED ( TotalBilled ), TotalBilled[customer_id] = CurrentName ),
            TotalBilled[Date]
        )
    Max date =
    VAR CurrentName =
        SELECTEDVALUE ( TotalBilled[customer_id] )
    RETURN
        MAXX (
            FILTER ( ALLSELECTED ( TotalBilled ), TotalBilled[customer_id] = CurrentName ),
            TotalBilled[Date]
        )

    Best Regards