Rolling sum of sales for three years

[Anonymous]

Hi,

I would like to calculate a rolling sum of sales for three years, the current and two previuos ones. An example is below:

[FreemanZ · Accepted solution]

hi @Anonymous 

try like:

NewCalculatedColumn =

VAR _year = [Year]

RETURN

SUMX(

    FILTER(

        TableName,

        TableName[Year] IN {_year, _year-1, _year-2}

    ),

    TableName[Sales]

)

[Anonymous]

Hi @FreemanZ ,

I am just trying to finilise my query. How would the measure look like if one more colomn, i.e. 'colour', had to be introduced?

[Anonymous]

This solution works well for me, thank you!

[FreemanZ]

hi @Anonymous 

or you can plot a table visual with the Year column and a measure like:

Measure =

VAR _year = MAX(TableName[Year])

RETURN

SUMX(

    FILTER(

        ALL(TableName),

        TableName[Year] IN {_year, _year-1, _year-2}

    ),

    TableName[Sales]

)