Post 2 of 5: “Dynamic Horizons” with #Excel ´s Dynamic Arrays 😅 here is a simple model where you can analyze data by time intervals: last 7 days, last month, last 3 years, 10 years maybe? and/or maybe see index variation % from a start date (switching charts), also you can add last 7-day-moving average or 5-day centered moving average … all possible with a bit of dynamic arrays and slicers (including time slicers 😎 assisted with #DAX ) As always you can download the file here 👉 https://lnkd.in/dN49MPM | chart name: “011: Dynamic Horizons”, now let´s dance and see you in 24 hrs for post 3 ✌😅