LTV CLIENTE

[EduardoAtalaia]

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

[EduardoAtalaia]

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

[amitchandak]

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

Would that date be from the dCalendar or order date?

[EduardoAtalaia]

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!