Rolling 4 Week Total

jdwalker5 , Prefer to have a separate table with Week on Year week depending on the data. If this year's week creates a rank column, for only week you use week in place of week rank

 

 

Week Rank = RANKX('Date','Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX('Date','Date'[Year Week],,ASC,Dense) //YYYYWW format

 

Last 4 weeks = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]>=max('Date'[Week Rank])-4 && 'Date'[Week Rank]<=max('Date'[Week Rank])))

 

Hi jdwalker5 

 

amitchandak  ThxAlot Thank you very much for your prompt reply. Here please allow me to post some of my methods.

 

For your question, here is the method I provided:

 

Here's some dummy data

 

“Table”

 

Create a measure.

 

 

Rolling 4 Week Total = 
    CALCULATE(
        SUM('Table'[Total]), 
        FILTER(
            ALL('Table'), 
            'Table'[Week] > MAX('Table'[Week]) - 4 
            && 
            'Table'[Week] <= MAX('Table'[Week])
        )
    )

 

 

 Here is the result.

Regards,

Nono Chen

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