Forecasting - question and help

Philip_Aarup — Tue, 27 Sep 2022 09:13:54 GMT

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.

Re: Forecasting - question and help

v-xiaotang — Wed, 28 Sep 2022 09:44:53 GMT

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.

topic Forecasting - question and help in DAX Commands and Tips

Forecasting - question and help

Re: Forecasting - question and help