Forecast calculation required in Power BI as per the FORECAST formula in excel.

[Ubedulla]

Hi,
I need to calculate forecast in Power BI, not using Analytical tab.
It should calculate as how FORECAST formula does in excel.
I tried calculating using Exponencial smoothing medthod in excel. But i did not get accurate result.

please help me with dax in power bi as how forecast formula does in excel.

[Ubedulla]

It would so greate if you can assiste me on caluculating forecast as excel furmula does.

[JoeBarry]

What are the attributes to the forecast? Is it an average of YTD or the last x months? If you can tell me this, then we can try and get a solution for you

[Ubedulla]

It should be on last x month. till december.

[Ubedulla]

Hi @JoeBarry 
Would you please update me the status.

[JoeBarry]

Hi Ubedulla

Please refer to this post https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Simple-Linear-Regression/td-p/24743...

[Ubedulla]

Hi JoeBarry,
This dax provides the results for one month, My scenario is forecast needs to calculated for till December.

[Ubedulla]

Hi @JoeBarry 
Data is same as it is in the screen short.
The data which is in the forecast column is calculated using Forecast formula in excel.

[JoeBarry]

Hi @Ubedulla 

Is the data the same as in the screenshot you provided?

I would create a couple of  measures and then add them to the visual

Actual Sales = SUM(Table1[Actual Sales]) 

forecasted Sales = SUM(Table1[Forcast])