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
Solved! Go to Solution.