Forum Discussion
Tricky Average
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: ...
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