Forum Discussion

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Could you please illustrate "trailing 12 month average" with examples? Do you mean you want to get the averate from 3/26/2017 to 2/26/2018 on 2/26/2018, and get average from 3/19/2015 to 2/19/2016 on 2/19/2016, etc? Also, please show us the formula of [Promoter %] and [Detractor %].

 

Besides, I found that you have posted two similar threads which have been answered. Do those solutions work in your scenario?
Trailing 12 Month Average

Trailing Average

 

Regards,

Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    v-yulgu-msft yes, what you've described is what I'm looking for. And here are screenshots of the formulas:

     


     

    And this formula below is what is currently displaying on my graph. I am not sure if this would be calculating everything correctly or if there's a better way:


    The 'Date'[Date] is coming from a generic Date table I've built. I created a Month End variable for using for my axis.