Monthly 12 Month Rolling Average

[LaurenceSD]

Hi,

I'm stuck on creating a rolling average for a month, rather than daily that I've created in the past. The scenario is, I've got some NPS scores that I want to display the 12 month rolling average, I think my normal measure is failing because of there are lots of days where the score is 0 because of no response.

Here's the data in a table

& here's the kind of outcome I'd be expecting

Any ideas on a measure to achieve this?

Thanks

[amitchandak · Accepted solution]

@LaurenceSD , Try a measure like with help from date table

Rolling 30 = calculate(AverageX(Values('Date'[MONTH Year]),[NPS],DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))

[LaurenceSD]

perfect, thanks very much