cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gladiator909
Helper I
Helper I

Projections in Power BI - Weighted Average

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, 202024
February 1, 202038
March 1, 202091
April 1, 202099
May 1, 20206
June 1, 202032
July 1, 202073
August 1, 202091
September 1, 202041
October 1, 202060
November 1, 202032
December 1, 20202
January 1, 202142
February 1, 202138
March 1, 202197
April 1, 202145
May 1, 202146
June 1, 202174
July 1, 202193
August 1, 202123
September 1, 202152
October 1, 202140
November 1, 202121
December 1, 202199
January 1, 202258
February 1, 202266
March 1, 202279
April 1, 202277
May 1, 202238
June 1, 202237
July 1, 202229
August 1, 202236
September 1, 202279
October 1, 202217
November 1, 202293
December 1, 202294

 

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

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

1 REPLY 1
lbendlin
Super User
Super User

lbendlin_0-1679620045550.png

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors