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

    Would that date be from the dCalendar or order date?