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

[Anonymous]

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?

[Greg_Deckler]

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

[Anonymous]

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.