In this tip, I show you how to use two parameters to create a view that allows the user to pick (1) the duration and (2) the date part to create a moving average calculation.
For example, this technique will allow the user to choose a 13-week moving average, a 6-month moving average, a 90-day moving average, etc.
Download the workbook here - https://www.vizwiz.com/2022/01/moving-average.html
Download
0 formats
No download links available.
How to Create a User Defined Moving Average | NatokHD