Forum Discussion
MAAbdullah_47
Helper V
Helper VDate Range calculation problems if the user select years Not consecutive
I have 2 Problems related to date Range: Problem-1 I have measure (CLTV) that calculatetes customer life time value (CLTV) https://blog.hubspot.com/service/how-to-calculate-customer-lifetime-value ...
AllisonKennedy
Community Champion
Community ChampionFor problem 1 can you just have them select start year and then do calculation based on the selected year and previous year?
What result do you want the measure to give if more than 2 consecutive years are selected?
What result do you want the measure to give if more than 2 consecutive years are selected?
MAAbdullah_47AllisonKennedy Sorry I ddnt understand your point can you explain,
If I Understand Your Question The CLTV start calculating from after the first year, in our example after the year 2014, so if the user select 2014 the result will be 0 , After that the User should select single or more than one year but should be consecutive (successive) e.g. 2015,2017,2018 , If the user select 2015,2017 it will calculate but it will not reflect the real correct case.
You can look at the measure (CLTV) in the pbix file.- MAAbdullah_47Still the problem didn't solved.