Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to get and display Forecast data

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!

Need Help
  • Kaly's avatar
    Kaly
    4 years ago

    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.

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

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

  • Kaly's avatar
    Kaly
    Icon for Resolver II rankResolver II
    4 years ago

    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.