Creating a forecast from Year To Date Values

Anything related to PowerPivot and DAX Formuale
Posts: 5
Joined: Mon Jul 24, 2017 7:58 pm

Creating a forecast from Year To Date Values

Postby Peter079 » Fri Nov 29, 2019 8:32 pm

Hi, I am struggling to solve the following scenario.

I have created a YTD measure that calculates actuals up to the end of a period e.g. November 2019, using the YTD function. My financial year end is March, and I am trying to figure out how I can add a Forecast Measure which is my YTD measure x 12/8 (or just annualising my YTD measure), and to then include this forecast measure in an Income Statement i.e. for the months of December to March, to get an annual value.

Any help will be greatly appreciated



Bernard Heymans
Posts: 28
Joined: Wed Feb 28, 2018 12:18 am

Re: Creating a forecast from Year To Date Values

Postby Bernard Heymans » Mon Dec 02, 2019 9:40 pm

Hi Forecasting is a different job...

you base it on exisiting results.

then you apply growth ratio on the data.

lets say you are selling cars

marketing say red cars should grow by 3%
Sales say our band is trendy and grow by 2% and that our sales in Germany will not go as good as in the rest of the world by 1%

so if our sales of red cars in germany are 1.748 units,

next year we will have

1.748 *(1+3%) *(1+2%) *(1-1%) = 1.818,08 cars

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 0 guests