Hi,
I have a Churn Rate calculation (below) and wondered how I go about amending this into the following please:
1. Cumulative calculation
2. Annual Comparison using the date variable 'OP_MORT'[Completion_date]
DIVIDE(
CALCULATE(
[Customer Count New],
'OP_MORT'[Acc_status] = "C"
),
[Customer Count New],
0
)
I have a Churn Rate calculation (below) and wondered how I go about amending this into the following please:
1. Cumulative calculation
2. Annual Comparison using the date variable 'OP_MORT'[Completion_date]
DIVIDE(
CALCULATE(
[Customer Count New],
'OP_MORT'[Acc_status] = "C"
),
[Customer Count New],
0
)