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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.