Budget / forcasting model in Power BI

[elkjoperik]

Hi!

I have a wish if I wonder is possible with Power BI

I have a data source with historical figures, and have blank values on YEAR (2018,2019,2020,2021) since there is no figures there yet.

Is it possible to create something that based on my forcasting that will fill inn figures for year 2018?

For example for year 2018

- Growth of  5%  (1.05)

- The growth is based on the 2017 result

For example for year 2019:

- Growth of 40% (1.40)

- The growth is based on the forcasted 2018 result that I did above

I've have included a file here so you can have a sample of what I'm talking about

Or must it be created a new table with a DAX-forumla that fetches actual figures and forcasts the blank fields?

[v-caliao-msft · Accepted solution]

@elkjoperik,

Forecasting in Power BI will allow you take a time series of data and make predictions or estimates about the future.  The forecasting tool is available in the analytics pane on Line charts.  At the moment it is only available in single value line charts. 

Please refer to the link below to see the details.
http://theexcelclub.com/forecasting-and-hind-casting-in-power-bi/

Regards,

Charlie Liao

[elkjoperik]

bump, anyone?