cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

August Community Highlights

Check out a full recap of the month!

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.

Top Solution Authors
Users online (646)