Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
I have a question, how to calculate and display the LTV (Lifetime Value) percentage of customers?
I still don't have the solution, could anyone help?
Not figuring out how to generate LTV percentage correctly!
Thank you for your attention!
@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
Would that date be from the dCalendar or order date?
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!