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?
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!