Sales Forecast using R in Power BI

Hi all,

I am doing a forecast on future sales quantity and here are the details of the problem.

- The history of the Quantity sold is loaded into Power BI.

- The history of the Holidays and Employee absence are also loaded into Power BI

- Both data are connected with TimeID Query.

- It is believed that part of the Sales variation can be explained by Holidays and employee(sales) absence.

Therefore now I would like to forecast future sales Quantity against time in the future, taking into factors of holidays and employee absence using R. Would it be possible to provide me with a sample code or sth so that I can implement into the Power BI?

I tried to use existing visuals to do the forecast but most of them yielded a straight line into the future....which is not really what I wished for....

Thanks in advance!

Best,

Qianru.