Forum Discussion
Solved
Weighted average by month
Hello everyone, Please, can you guide/help me? I have the below table and I need to calculate the weighted average by month, the formula in excel for the Weighted average by month = (Column B*Co...
Thank you, pankajnamekar25 , bhanu_gautam , ThxAlot , and Ashish_Mathur , for your responses.
Hi GiaD30,
Please find attached the screenshots and PBIX file, which may help in resolving the issue:
If you find our response helpful, kindly mark it as the accepted solution and give kudos. This will assist other community members facing similar queries.Thank you.
bhanu_gautam thank you so much for your reply, unfortunately, the result is the same with the numbers from column B, I also tried something similar.
I need the result from column Weighted average from my table below.
| Date | Column B | Column C | weighted average |
| 2/3/2024 | 10 | 100 | 1.052631579 |
| 2/4/2024 | 15 | 120 | 1.894736842 |
| 2/5/2024 | 23 | 200 | 4.842105263 |
| 2/6/2024 | 12 | 210 | 2.652631579 |
| 2/7/2024 | 11 | 320 | 3.705263158 |
| 3/3/2024 | 22 | 250 | 5.97826087 |
| 3/4/2024 | 40 | 200 | 8.695652174 |
| 3/5/2024 | 45 | 115 | 5.625 |
| 3/6/2024 | 33 | 137 | 4.914130435 |
| 3/7/2024 | 9 | 218 | 2.132608696 |