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

Question

The initial sales forecast is the&nbsp;average of previous 6 periods.For period 8, the calculation of sales forecast&nbsp; =G$1*B8+(1-G$1)*C8.How do you&nbsp;write this forecast in DAX?

greg_deckler · Answer

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 · Answer

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.&nbsp; I need help.&nbsp;

Forum Discussion

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

2 Replies

Related content

Smooth lines

Forecasting with DAX

Forecasting

MS Fabric Pricing/Bursting/Smoothing

Live Weather Forecast Dashboard