Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
12-12-2017 23:58 PM
Many faces of forecasting ...
Attached sample contains 4 fifferent ways to perform forecasting with exponential smoothing algorithm.
1) Using R-powered Custom Visual
2) Using R-visual
3) Using R-in-Power Query (data transform with R)
4) Using new "forecasting" option in good old Line Chart
Do not forget to install required R packages
The R code inside Power Query step is also attached (and also accessible in PBIX)
Why are the dates in the resultset skewed? Originally they are all first days of each month, as the first one in the screenshot below.
The algorithm only works with equally spaced dates. Therefore the original dates are resampled to become equally sampled in the range from first to last dates
Thanks very interesting, it demonstrates the potentialities of the product that many people can not understand at the moment