Loop in R Script

[Anonymous]

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 

[v-danhe-msft]

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

[Anonymous · Accepted 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, 

[v-danhe-msft]

Hi @Anonymous,

Could you please mark one reply as Answered to close this topic?

Regards,

Daniel He