topic Rolling sum of sales for three years by colour in DAX Commands and Tips

Rolling sum of sales for three years by colour

Anonymous — Mon, 06 Feb 2023 04:56:36 GMT

Hi,

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

Re: Rolling sum of sales for three years by colour

FreemanZ — Mon, 06 Feb 2023 05:55:47 GMT

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:

Re: Rolling sum of sales for three years by colour

Anonymous — Mon, 06 Feb 2023 08:53:29 GMT

Thank you! It worked well.

Re: Rolling sum of sales for three years by colour

Anonymous — Mon, 06 Feb 2023 08:53:45 GMT

FreemanZ
Thank you! It worked well.