Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

extrapolation formula dax issue

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

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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