Forecasting - question and help

[Philip_Aarup]

Hi all, 
I have created a simple forecasting function which predicts the incoming calls from our customers the next 12 month. 
Likewise a slicer have been created which makes it possible to change the growth percentage to see the change. 

Incoming Calls (Eligible) - Forecast =

VAR Forecast =

CALCULATE(

'Incoming Measures'[Incoming Calls (Eligible)],

DATEADD('Calendar'[Date], -1, YEAR)

)*(1+'Incoming Calls forecast'[Incoming Calls forecast Value])

RETURN

IF(

DATE(YEAR(MAX('Calendar'[Date])),MONTH(MAX('Calendar'[Date])),DAY(MAX('Calendar'[Date])))>=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())),

Forecast,

'Incoming Measures'[Incoming Calls (Eligible)]

My struggle is that I would love to have set up with another measurement on our Abandon Rate (AR%). 
For example, if the predicted growth is 5% the next 12 months, how does that affects the AR% - is that even possible? 

Thanks for your help 🙂 
Have a great day. 

[v-xiaotang]

Hi @Philip_Aarup 

Thanks for reaching out to us.

>>My struggle is that I would love to have set up with another measurement on our Abandon Rate (AR%). 
For example, if the predicted growth is 5% the next 12 months, how does that affects the AR% - is that even possible? 

if I understand correctly, you can create a measure to get the predicted growth in the next 12 months, then you can use the if() function in another measure to determine whether the [predicted growth] measure reaches 5%

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.