cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Exponential Smoothing Forecast in Query Editor using R

I need help with implementing Forecasting models using R in Query Editor with the below dataset

DateSKUValue1Value2Value3
01-Jan-18A281625
01-Feb-18A221816
01-Mar-18A162315
01-Apr-18A191226
01-May-18A102530
01-Jun-18A241928
01-Jul-18A222028
01-Aug-18A252212
01-Sep-18A231115
01-Oct-18A132415
01-Nov-18A192721
01-Jan-18B301815
01-Feb-18B111430
01-Mar-18B261220
01-Apr-18B242519
01-May-18B182629
01-Jun-18B132811
01-Jul-18B242821
01-Aug-18B201523
01-Sep-18B271013
01-Oct-18B292217
01-Nov-18B131712
01-Jan-18C112018
01-Feb-18C212117
01-Mar-18C152125
01-Apr-18C141215
01-May-18C132217
01-Jun-18C202418
01-Jul-18C271430
01-Aug-18C221225
01-Sep-18C271424
01-Oct-18C201930
01-Nov-18C212516


Please I want to implement reusable R Code with clarification of parameters or variables for (Date, Value1, Value2, Value3), the required packages for R?

Thanks in advance

1 REPLY 1
Highlighted
Community Champion
Community Champion

Re: Exponential Smoothing Forecast in Query Editor using R

@Mohamed-Ashraf 

Please check out these links if they will be useful to you.

https://community.powerbi.com/t5/Desktop/Forecast-Table-R-script/m-p/197834
https://academy.dataiku.com/time-series-with-code-open
https://pawarbi.github.io/blog/forecasting/python/powerbi/forecasting_in_powerbi/2020/04/24/timeseri...


________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn


Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.