Forum Discussion
Moving daily average with offset
sdgiss If you want the average to span 21 days, then it will need to be 27 days ago to 7 days ago (since you are use = on both ends it is inclusive, otherwise you'd need to use 28).
When you say 21 day moving average offset, what are you wanting to acheive? I think the 27 (or 28 without 😃 is what you're looking for?
You were a great help AllisonKennedy! You helped confirm that my first formula might be the one to move forward with. The one from amitchandak is more straightforward and convenient but it doesn't work as a measure with time intelligence functions. If I can't find a way to resolve this issue then I will likely elevate your response to the solution.
Thank you, and Happy New Year!
sdgiss What do you mean when you say 'it doesn't work as a measure with time intelligence functions'. If you can add more detail on what's not working, we can hopefully help you resolve the issue. 🙂 Happy New Year to you too!
AllisonKennedy my sincere apologies for not responding to this sooner. It has been a hectic few months.
Did you see the error message when trying to use the suggestion from Amit? I have the measure in there as well. When I place the original equation (the one you validated for me) I have no issues with the measure output, however with Amit's suggestion it makes the measure unusable.
Thank you!