Forcasting the values (2023-2028), based on 2022 data

[Anonymous]

Hi Power BI community,

I need to forcast the values for year 2023 to 2028. I have the value of  year 2022

The calculations I want to used is;

Forcastvalue of 2023 = 2022[Value]x(1+20%)
Forcastvalue of 2024 = [Forcastvalue of 2023]x(1+20%) and so on till 2028

I have created the DateTable from 2019-2028 for the forcast and I want to use that table as filter/slicer. 
So, if i click on 2022 it must show current year values and when I click on 2023 and next years, it must show the forcasted values based on above calculations

Thank you

[Anonymous · Accepted solution]

Hi @Anonymous ,

My easy sample is as below.

Year = GENERATESERIES(2022,2028,1) 

Meausre:

Actual and Forecast = 
VAR _Current_Year =
    YEAR ( TODAY () )
VAR _Select_Year =
    SELECTEDVALUE ( 'Year'[Year] )
VAR _DIFF = _Select_Year - _Current_Year
VAR _2022 =
    CALCULATE ( SUM ( 'Table'[Value] ) )
RETURN
    IF (
        _DIFF = 0,
        _2022,
        PRODUCTX ( GENERATESERIES ( 1, _DIFF, 1 ), 1.2 ) * _2022
    )

 Result is as below.

Best Regards,
Rico Zhou

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