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.
I need help with implementing Forecasting models using R in Query Editor with the below dataset
Date | SKU | Value1 | Value2 | Value3 |
01-Jan-18 | A | 28 | 16 | 25 |
01-Feb-18 | A | 22 | 18 | 16 |
01-Mar-18 | A | 16 | 23 | 15 |
01-Apr-18 | A | 19 | 12 | 26 |
01-May-18 | A | 10 | 25 | 30 |
01-Jun-18 | A | 24 | 19 | 28 |
01-Jul-18 | A | 22 | 20 | 28 |
01-Aug-18 | A | 25 | 22 | 12 |
01-Sep-18 | A | 23 | 11 | 15 |
01-Oct-18 | A | 13 | 24 | 15 |
01-Nov-18 | A | 19 | 27 | 21 |
01-Jan-18 | B | 30 | 18 | 15 |
01-Feb-18 | B | 11 | 14 | 30 |
01-Mar-18 | B | 26 | 12 | 20 |
01-Apr-18 | B | 24 | 25 | 19 |
01-May-18 | B | 18 | 26 | 29 |
01-Jun-18 | B | 13 | 28 | 11 |
01-Jul-18 | B | 24 | 28 | 21 |
01-Aug-18 | B | 20 | 15 | 23 |
01-Sep-18 | B | 27 | 10 | 13 |
01-Oct-18 | B | 29 | 22 | 17 |
01-Nov-18 | B | 13 | 17 | 12 |
01-Jan-18 | C | 11 | 20 | 18 |
01-Feb-18 | C | 21 | 21 | 17 |
01-Mar-18 | C | 15 | 21 | 25 |
01-Apr-18 | C | 14 | 12 | 15 |
01-May-18 | C | 13 | 22 | 17 |
01-Jun-18 | C | 20 | 24 | 18 |
01-Jul-18 | C | 27 | 14 | 30 |
01-Aug-18 | C | 22 | 12 | 25 |
01-Sep-18 | C | 27 | 14 | 24 |
01-Oct-18 | C | 20 | 19 | 30 |
01-Nov-18 | C | 21 | 25 | 16 |
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
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |