extrapolation formula dax issue

[Anonymous]

Hi all,

I am looking fot forcasting in the future, however I am getting results in the past.

Jobs Kosten 30D = IF ( ISBLANK( [TotalJobKosten]);
BLANK();
AVERAGEX(
    DATESINPERIOD(
    Dim_Date[DateKey];
    LASTDATE(Dim_Date[DateKey]);
    -30;DAY); 
    [TotalJobKosten]))

Jobs Forecast = IF ( ISBLANK( [TotalJobKosten]); CALCULATE([Jobs Kosten 30D]; SAMEPERIODLASTYEAR(Dim_Date[DateKey])
  
      ); BLANK())

The result in the chart what I get is:

the dark blue in the past is not what i want

Can anyone help?

Kind regards,

Ezz

[Anonymous]

Hi @Anonymous ,

As checked the formula of your measure "Jobs Forecast", it will return the data of last year not future... The Forecasting feature is available for the line chart, you can select the related line chart and set the forecast options in "Analytics" pane just like below screen shot.

Forecast

You can refer the contents in following links for more details.

Forecasting in PowerBI

How to forecast sales with Power BI

Best Regards

Rena