Forum Discussion
Averaging a Measure
I have a table with survey results. I also have a date table with an inactive realationship setup between the 2 using the survey date from the survey results table and the date from the table. The Mo...
Hi Anonymous
Could you please illustrate "trailing 12 month average" with examples? Do you mean you want to get the averate from 1/31/2017 to 1/31/2018 on 1/31/2018, and get average from 3/31/2017 to 3/31/2018 on 3/31/2018, etc?
How about trying this formula
Measure2 = AVERAGEX(SUMMARIZE(ALL Survey Data, ALL Survey Data [MonthEnd], "12month", [ positive %]), [ positive %])
Additionally, here is a similar post.
Calculate Average Trailing 12 Months
Best Regards
Maggie
v-juanli-msft yes, that's exactly what I mean! One small issue. My [Month End] column is coming from my Date table, not my All Survey Data table. How could I modify it to reference that? Or should I just make a month end column from my All Survey Data table? I wasn't sure if it was possible since there are gaps everywhere in that table with the dates.