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.
Hi,
I need help with a code for R script. I need to use Arima.
I have 3 years of sales data on month level, for X number of store and Y number of categories.
I need to create a forecast per store, per category for the next 3 months (on month level), and I need the data to be written to a table so that I can make measures using this data.
I can get it to run for one store, one category, but I need R to somehow do a loop, so that I get the forecast for each store and each category. So, when finished with the first category for Store 1, I need it to do the same for category 2 - Store 1. When it is done with all categories for Store 1, it needs to move on to store 2 and do the same for all categories.
Example of data:
Month | Store Name | Category |
01.2018 | Store 1 | Category 1 |
01-2017 | Store 1 | Category 1 |
01-2016 | Store 1 | Category 1 |
01.2018 | Store 1 | Category 2 |
01-2017 | Store 1 | Category 2 |
01-2016 | Store 1 | Category 2 |
01.2018 | Store 2 | Category 1 |
01-2017 | Store 2 | Category 1 |
01-2016 | Store 2 | Category 1 |
Thank you in Advance.
/Kristina
Solved! Go to Solution.
Hi,
Sorry I forgot to say that it is R Script in Power BI I want to use, but yes maybe I can try and ask there.
Thank you,
Hi @Anonymous,
Due to this community is for Power BI, I suggest you recreate this topic in R community:
https://community.rstudio.com/
Regards,
Daniel He
Hi,
Sorry I forgot to say that it is R Script in Power BI I want to use, but yes maybe I can try and ask there.
Thank you,
Hi @Anonymous,
Could you please mark one reply as Answered to close this topic?
Regards,
Daniel He
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |