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 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!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors