Forum Discussion
Customer / Member Tenure
Hello Community. I am seeking your assistance to create a measure for customer (member) tenure. I would like the mesaure to calculate tenure based on the period of time between 'membership_start_dat...
Hi Anonymous ,
Is this the result you expected?
Or do you want to calculate by the last order date of each customer?
I created a pbix to see if it meets your needs.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Perhaps:
Member Tenure_nmbr (Today) = FLOOR(IF('UNION Transaction Table'[membership_start] < TODAY(), DATEDIFF('UNION Transaction Table'[membership_start], MAXX(FILTER('Table',[member_name] = EARLIER([member_name])),[order_date]), DAY) / 365.25, 0), 1)
Member Tenure_nmbr (Today) = FLOOR(IF('UNION Transaction Table'[membership_start] < TODAY(), DATEDIFF('UNION Transaction Table'[membership_start], MAXX(FILTER('Table',[member_name] = EARLIER([member_name])),[order_date]), DAY) / 365.25, 0), 1)