Forum Discussion
Customer Activation calculation
Dear Community I need to calculate the activation rate for customers in a given period of time. The measure is defined as: Тhe numerator: Count of first transactions in a given period of time ma...
Hi KonradP ,
You can try to create a new column with RANKX() function based on date and customer columns. Then calculate the count where rank =1.
You could share your sample data and excepted result to us if you don't have any Confidential Information.
I provided some details about the model and sample data table. Would mind checking out?