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:
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?
Go to Solution.
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.