Holt Winter's Multiplicative Approach logic...

[ArunS]

Hello people,
I am a demand planning executive working for a beverage organization.
Am in the process of modalling a demand planning template.Having said that its always good to have a tool in place.However before such a tool is implemented,I would like to try the potential of powerpivot in peeparing a template.
Would like to know if there is a logical formula in PowerPivot Dax for Holt Winter's Multiplicative Statistical Approach.

BR,
ArunS

 

[Matt Allington]

I saw the post but I don't know anything about the Holt Winters stuff - hence I didn't reply originally. I know there is a new forecasting tool in Excel 2016 that I saw at PASS BA Conf this year

as for Power Pivot, I am sure it isn't a standard function, however if you know how to do it in Excel using standard formulas, then maybe it can be done. I just did some quick research, and noticed references to using XL solver , But I don't see any examples using Excel formulas. Do you know how to do it natively in Excel by chance? If so maybe you can send me a workbook and I'll take a look at the formulas, and then let you know if I think it's possible.

 

[ArunS]

Dear Matt,

Thank you very much for your response. I will be all the more glad to share with you my workbook. Can you please pm me your email id so that I can send you the file as an attachment. OR is it possible to attach and send you exclusively through this website.

BR,
ArunS

 

[Matt Allington]

Well I would PM you my email, but apparently your PM box is full. You can get my email from my website Excelerator BI

 

[TimRodman]

By the way, Excelerator BI is a link in the previous reply. I wish links displayed better on this site