Tricky Average

[Anonymous]

I have this table with survey data:

 

I've been asked using this data to create a trailing 12 month average of my [Positive %] measure. Here are the pieces of each measure in case it helps:

Positive Count:

Total Count:

Positive %:

 

Then from there I've been asked after figuring out the trailing 12 month piece to use those values to get the average of the previous quarter. Is that even possible given this data?

[v-piga-msft]

Hi @Anonymous，

Do you want to calculate the average value of previous quarter based on the value of trailing 12 month?

Besides, for my knowledge, the July, August and September should be Quarter 3 but in your table it shows Quarter 4.

Am I missing somthing? 

Could you provide more details for you data and I would appreciate it if you could show your desired output.

Best Regards,

Cherry