Rolling sum of sales for three years by colour

[Anonymous]

Hi, 

I would like to find a rolling sum for three years for every colour provided.

[Anonymous]

@FreemanZ 
Thank you! It worked well.

[Anonymous]

Thank you! It worked well.

[FreemanZ · Accepted solution]

hi @Anonymous 

try to plot a visual with year and colour columns, and a measure like:

3YColourSum = 
VAR _year = MAX(TableName[year])
RETURN
SUMX(
    FILTER(
        ALL(TableName),
        TableName[Colour] = MAX(TableName[Colour])
            &&TableName[Year] IN {_year, _year-1, _year-2}
    ), 
    TableName[Sales]
)

it worked like: