Open Side Menu
Skip to contentBrand Logo
Forums
Inspiration
Ideas
Communities
Blogs
Learning
Support
RegisterSign In
  1. Microsoft Fabric Community
  2. Power BI forums
  3. Galleries
  4. R Script Showcase
Sharon's avatar
Sharon
Microsoft Employee
10 years ago

Forecasting

Description Forecasting is used to predict next points in time series data sets. The prediction in this example is based on trend and seasonality.     Prerequisites (The sample .pbix file...
Forecasting Showcase.pbix635 KB
ScriptInstallPackagesWithWorkaroundsForecast.R1 KB
Advanced Analytics Visualizations
Anonymous's avatar
Anonymous
Not applicable
10 years ago

To those who have issues with "Error in if (frequency > 1 && abs(frequency - round(frequency)) < ts.eps) frequency <- round(frequency) :" it turns out R uses your local language setting to determine a month name... 

If you add the following to you R-script it should force the code to use english setting:

Sys.setlocale("LC_ALL","English")

Make sure to add it the to top of the code

 

Hope this helps you too :

HMonteiro's avatar
HMonteiro
New Member
10 years ago

Solved! Many thanks!

  • JuliaYebra's avatar
    JuliaYebra
    Helper III
    10 years ago

    Anonymous excellent!!!! Thank you!!!

    • shreekishore's avatar
      shreekishore
      Frequent Visitor
      9 years ago

      Could you send any one the source file births.csv file.

       

      Thanks,

    • shreekishore's avatar
      shreekishore
      Frequent Visitor
      9 years ago

      Could you send any one the source file births.csv file.

       

      Thanks,

  • shreekishore's avatar
    shreekishore
    Frequent Visitor
    9 years ago

    please send Births.csv file 

    • Jacob_Minsky's avatar
      Jacob_Minsky
      Microsoft Employee
      9 years ago

      I am attaching the births.xlsx file used to create this visual.

      births.xlsx65 KB
  • © 2026 Microsoft
  • Manage cookies
  • Privacy & cookies
  • Terms of use
  • Trademarks
Your Privacy Choices Consumer Health Privacy