cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

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?

Forecasting.png

2 REPLIES 2
Highlighted
Super User IV
Super User IV

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

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


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Frequent Visitor

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

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.

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.