topic How do you write sales forecast in DAX using Exponential Smoothing. in DAX Commands and Tips

How do you write sales forecast in DAX using Exponential Smoothing.

Anonymous — Mon, 09 Mar 2020 02:34:54 GMT

The initial sales forecast is the average of previous 6 periods.

For period 8, the calculation of sales forecast =G$1*B8+(1-G$1)*C8.

How do you write this forecast in DAX?

Re: How do you write sales forecast in DAX using Exponential Smoothing.

Greg_Deckler — Mon, 09 Mar 2020 03:45:55 GMT

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Re: How do you write sales forecast in DAX using Exponential Smoothing.

Anonymous — Mon, 09 Mar 2020 04:04:07 GMT

Thank you for the link.

It is very helpful for the beginner like me to read your article.

I have tried to us the function "earlier" but with no success, since the forecast depend on the previous calculation result of the same column. I need help.