In my application this approach collected an extra month's worth of data. The corrected forumula which worked for me is below. I tested this with manual calculations in Excel.
[Trailing 12 Month Average ] = DIVIDE(
Hi, how can this be calculated if there are duplicate dates?
I have a DateTime column which has values for different timestamps on the same date. All the values are to considered while calculating the Average.
I exactly followed yoru approach but my moving averages are the same as the nomal averages for each month. It looks like other people are having the same issues. Any insights?