Hi there,
I have a table of dates and price and I am trying to apply a weighted average formula to determine future pricing.
Here is an example of the table:
Date Price
| January 1, 2020 | 24 |
| February 1, 2020 | 38 |
| March 1, 2020 | 91 |
| April 1, 2020 | 99 |
| May 1, 2020 | 6 |
| June 1, 2020 | 32 |
| July 1, 2020 | 73 |
| August 1, 2020 | 91 |
| September 1, 2020 | 41 |
| October 1, 2020 | 60 |
| November 1, 2020 | 32 |
| December 1, 2020 | 2 |
| January 1, 2021 | 42 |
| February 1, 2021 | 38 |
| March 1, 2021 | 97 |
| April 1, 2021 | 45 |
| May 1, 2021 | 46 |
| June 1, 2021 | 74 |
| July 1, 2021 | 93 |
| August 1, 2021 | 23 |
| September 1, 2021 | 52 |
| October 1, 2021 | 40 |
| November 1, 2021 | 21 |
| December 1, 2021 | 99 |
| January 1, 2022 | 58 |
| February 1, 2022 | 66 |
| March 1, 2022 | 79 |
| April 1, 2022 | 77 |
| May 1, 2022 | 38 |
| June 1, 2022 | 37 |
| July 1, 2022 | 29 |
| August 1, 2022 | 36 |
| September 1, 2022 | 79 |
| October 1, 2022 | 17 |
| November 1, 2022 | 93 |
| December 1, 2022 | 94 |
What I am trying to do is find the price for January 2023, Feb 2023, March 2023 etc based on the years 2020, 2021, 2022 by using a weighted average formula so something like
Jan2023 = 0.2*Jan2020 + 0.3*Jan2021 + 0.5*Jan2022
Same forumla applies for Feb2023, March2023 etc
This would be fairly simple to implement in excel but I cannot seem to find a way to start it in Power BI.
Anyone has any tips on how to get that started?
Thank you
