Forum Discussion

Philip_Aarup's avatar
Philip_Aarup
New Member
3 years ago

Forecasting - question and help

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. 

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    3 years ago

    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.