Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |