Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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 , 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))
perfect, thanks very much
User | Count |
---|---|
88 | |
88 | |
74 | |
67 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |