Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Mohamed-Ashraf
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
Fowmy
Super User
Super User

@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


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.