Forum Discussion
Claim Frequency & Claim Forecasting
Hi Team, Im preparing the Claims Forecasting for 2020. I have 4 Tables(Sales, Claims, Product & Calendar). In Sales Table (Contract Number, Contract Start Date, Contract End Date) In Claims ...
Yeah, I know how you calculate a forecast based on the PY period. But I have not got an answer to my question: Why can't you just sum all the forecasts for all the months of 2020? If you know the percentage for each month of 2019, then it's easy to do this:
sum over all i = 1,2,...,12 (all months of 2019):
claim_freq(i) * active_policies(i+1year)
Why can't you use it?
Best
D
sum over all i = 1,2,...,12 (all months of 2019):
claim_freq(i) * active_policies(i+1year)
Why can't you use it?
Best
D
Hi,
I am using this measure now
1.Claim Frequency LY = Calculate([Claim Frequency], SAMEPERIODLASTYEAR(Calendar[Date])
2. Forecast = [Total Active Policies]*[Claim Frequency LY]
In Visual im filtering only Year 2020 and Month wise breakup.