cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
elkjoperik Regular Visitor
Regular Visitor

Budget / forcasting model in Power BI

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-caliao-msft
Moderator

Re: Budget / forcasting model in Power BI

@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

 

View solution in original post

2 REPLIES 2
elkjoperik Regular Visitor
Regular Visitor

Re: Budget / forcasting model in Power BI

bump, anyone?

Moderator v-caliao-msft
Moderator

Re: Budget / forcasting model in Power BI

@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

 

View solution in original post

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors