How to get and display Forecast data

[Anonymous]

Hello

I have actual data until current month. I have used forecasting pbi tool to project until end of year. 

I want to disply the forecasted value of december but I don't find how to do that.

Do you have a tips on that?

Thanks!

[Kaly · Accepted solution]

Hi @Anonymous ,

According to your description, the logic of calculating the forecast values is not indicated. I create a sample.

For example you want to take the average of the sales for the previous six months as a forecast value, create a measure:

Forecast =
IF (
    MAX ( 'Table'[Sales] ) = BLANK (),
    CALCULATE (
        AVERAGE ( 'Table'[Sales] ),
        DATESINPERIOD ( 'Table'[Month], MAX ( 'Table'[Month] ), -7, MONTH )
    )
)

Get the correct result.

Best Regards,

Kaly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?