Forum Discussion
Helper IINeed Help in writing DAX functions 2 get Current, Previous term premium of policy in calculated col
Here's a framework that computes your columns. You can take it from there to compute the buckets.
Helper IIThank you so much. I appreciate you.
For policy No TAL982X762 Prev Term Renewed Prem obtained is 726, (the value which corresponds to the policy_renewed event prior to the cancellation.
But there is an event called update_policy on 21-09-2022, of premium 115.81. This update policy event on 21.09.2022 has fallen between the Policy_renewed event on 11-08-2022 and cancel_policy_non_payment event on 18.04.2023. In such cases is there any way to add the 115.81 value to the policy renewed event value 726 before cancellation such that 841.81 (726+158.11 = 841.81) value gets populated in the Previous Term Renewed Prem instead of 726 as obtained by DAX function in the file. In general, any update in premium before cancellation and after the immediate policy_renewed event before cancellation of policy to be added policy renewed premium.
Further how to modify the DAX functions of Current Term Premium and Prev Term Renewed Prem to get values for the policies which are not cancelled (excluding the policies cancelled) for the events create_policy, policy_renewed.
To get the survival count for increase in the premium.
Added last 4 records of a policy which is active.