Rolling 4 Week Cash Flow

Hi Anonymous ,

Since you did not give a specific table, I had to create my own table for testing according to your description, please point out if there are any problems.

Please try below steps:

1. below is my test table

Table:

2. add a new column with below dax formula

Index = RANKX('Table',[FW EndOfWeek],,ASC)

3. create a measure and add it to table visual

Measure =
VAR cur_index =
    SELECTEDVALUE ( 'Table'[Index] )
VAR tmp =
    FILTER (
        ALL ( 'Table' ),
        'Table'[Index] >= cur_index - 3
            && 'Table'[Index] <= cur_index
    )
VAR sum_for_4weekly =
    SUMX ( tmp, [Weekly Cash Flow] )
RETURN
    IF (
        cur_index < 4,
        SELECTEDVALUE ( 'Table'[Weekly Cash Flow] ),
        sum_for_4weekly
    )

Please refer the attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.