Forum Discussion

readyOH's avatar
readyOH
Frequent Visitor
10 years ago
Solved

How to do a Forecast?

Hi,   I know that the forecast functionnality has been removed from PowerBI https://support.powerbi.com/forums/265200-power-bi/suggestions/8790061-add-forecasting-feature   but do you have a form...
Need Help
Show and Tell
Tutorial Requests
djohnson's avatar
djohnson
Advocate I
8 years ago

The one thing you will have to do is have a separate table with the dates - which is a parent to the table with the actuals and the forecast DAX. Otherwise, the DAX formula only looks at previous dates. If you look at the example file in the article, you will see the date table and the joins. Hope this helps.

 

http://fountainanalytics.com/wp-content/uploads/2016/09/TimeSeriesForecast.zip

 

D

SGLake's avatar
SGLake
Frequent Visitor
8 years ago

David,

Do you think there could be an issue with your prior day formula? It's referring to the site_data[date], -1 but the others like prior week are looking at the CSV_datelookup[date].

 

Pageviews (Prior Day) =
SUMX(
CALCULATETABLE(Site_Data,
DATEADD(ALL(Site_Data[Date]),-1,DAY),
ALL(Site_Data[Date])),
Site_Data[Pageviews])

 

Pageviews (Prior Week) =
SUMX(
CALCULATETABLE(Site_Data,
DATEADD(CSV_Datelookup[Date],-7,DAY),
ALL(Site_Data[Date])),
Site_Data[Pageviews])