Forecast per Company distributed yearly

Hi, Anonymous 

You can create a new measure, try the following DAX expression:

Forecast = 
VAR LastYear = MAX('Table'[Year])
VAR GrowthRate = 0.07 -- Adjust this based on your data
RETURN
SUMX(
    FILTER(
        'Table',
        'Table'[Year] >= LastYear
    ),
    'Table'[Revenue] * (1 + GrowthRate)
)

If you want to select 2022, the table will show numbers for 2022 and beyond instead of 2017, you can create a new table

Table 2 = VALUES('Table'[Year])

Then create a new measure:

Revenure measure = 
VAR _Slicer = MAX('Table 2'[Year])
RETURN 
IF(MAX('Table'[Year])<_Slicer,BLANK(),SUM('Table'[Revenure]))

Put revenure measure and Forevast in matrix view, and put table 2 [year] in slicer view:

Here is my preview:

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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