Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am trying to calculate future 12 months moving average based on the last 8 months.
Now we are in 2023 (next year will be 2024), so I will need to calculate this for 2024 (next year for 2025). In January 2024 I will take data from May-December2023, for February 2024 I will take data from already calculated January 2024 and June-December 2023, and so on.
All I found on the community is this formula:
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |