Forum Discussion

ravi_ch's avatar
ravi_ch
Icon for Helper I rankHelper I
4 years ago
Solved

Forecast for next 1 year

I want to forecast from 4/10/2021 to 31/12/2022 Using last year data + 10% for forecast. For that first i calculated forecast amount Then i use if statement like if date is greater than 3/10/202...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  ravi_ch ,

     

    Modify "3/10/2021" as Date(2021,3,10),see below:

    Web search Interest Forecast (Power BI) =
VAR Forecast =
    CALCULATE (
        [AVG websearch Interest (Power BI)],
        DATEADD ( 'Date table'[Date], -1, YEAR )
    ) * ( 1 + 0.1 )
RETURN
    IF (
        MAX ( 'Date table'[Date] ) > DATE ( 2021, 3, 10 ),
        Forecast,
        [AVG websearch Interest (Power BI)]
    )

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi  ravi_ch ,

 

Modify "3/10/2021" as Date(2021,3,10),see below:

Web search Interest Forecast (Power BI) =
VAR Forecast =
    CALCULATE (
        [AVG websearch Interest (Power BI)],
        DATEADD ( 'Date table'[Date], -1, YEAR )
    ) * ( 1 + 0.1 )
RETURN
    IF (
        MAX ( 'Date table'[Date] ) > DATE ( 2021, 3, 10 ),
        Forecast,
        [AVG websearch Interest (Power BI)]
    )

And you will see:

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!