Create 4 week rolling flag on previous or next weeks

Hi jaco1951,

For what I know, I assume you have a table with forecast value and YearWeek column, you should follow the steps below.

1. Please create a new table by clicking "New Table" under Modeling on home page, the new table only include [YearWeek] column. Note: there is no relationship between YourTable and new table. Please replace the 'YourTable' as your fact table name.

YearWeekTable = SELECTCOLUMNS('YourTable',"YearWeek",'YourTable'[YearWeek])

2. Create two measures to get the selected week in slicer and the Next 4 week value.

SelectedWeek=SELECTEDVALUE('YourTable'[YearWeek])


Next_4_week =[SelectedWeek]+4

3. Then create another measure to get theforecast values for next weeks.

Next_4_weekvalues =
CALCULATE (
    MAX ( YourTable[Forecast_value] ),
    FILTER (
        'YourTable',
        AND (
            'YourTable'[YearWeek] >= [SelectedWeek],
            'YourTable'[YearWeek] <= [Next_4_week]
        )
    )
)

4. Finally, you create a table to display your result. There is a similar thread here for your reference. And please feel free to ask if you have any other question.

Best Regards,
Angelia