Forum Discussion

EduardoAtalaia's avatar
EduardoAtalaia
Frequent Visitor
4 years ago

LTV CLIENTE

Hello!
I have a question, how to calculate and display the LTV (Lifetime Value) percentage of customers?

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    EduardoAtalaia , LTD you can get like this

     

    LTD(complete till date) =
    var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
    var _min = minx(all('Date'), 'Date'[Date]) // or minx(allselected('Date'), 'Date'[Date])
    return
    CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

     

    % depend on what you want

    • EduardoAtalaia's avatar
      EduardoAtalaia
      Frequent Visitor
      4 years ago

      Percentage would be total LTV, for example:
      customer-1 $1000 % what percentage
      Customer-2 $4500 % ||
      Customer-3 $4000 % ||
      total $9500
      The doubt how to calculate the percentage!

  • EduardoAtalaia's avatar
    EduardoAtalaia
    Frequent Visitor
    4 years ago

    I still don't have the solution, could anyone help?
    Not figuring out how to generate LTV percentage correctly!
    Thank you for your attention!