Forum Discussion
Forecast future 18 months
Hi All,
I am trying to calculate the forecast for this data for the next 18 months. The 18 months need to be dynamic and only when the status is "Active".
The forecast figure for the next 18 months is the budget figure divided by 9.
This forecast needs to show on a table for the 18 months straight and not just in the total.
See the data example below and thanks in advance.
8 Replies
BGB Maybe use simple linear regression? Simple Linear Regression - Microsoft Power BI Community
Greg_Deckler There is no need for prediction in this one. The forecast just needs to have the total budget divided by 9 for months greater than this month.
BGB So like this?
Measure = VAR __Project = MAX('Table'[Project ID]) VAR __Budget = SUMX(FILTER(ALL('Table'),[Project ID] = __Project),[Budget]) RETURN __Budget / 9To help with this, my desire outcome is below.
