- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Help with Weighted Moving Average for delay delivery
Dear Community,
hope you can assist. I am struggling with finding the correct way to calculate in Power Bi the Weighted Moving Average for delay delivery.
Here is the case, assuming that we are running different project, and for each project we have expected delivery date. If that date is missed we have delay. Need now to calculate the weighted moving average for this delays in PBI.
Is that possible?
Thanks for help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi Ryan,
apologies for the late reply, really sorry for that.
Please see below a better example:
I would like to calculate in DAX the weighted moving average of last 6 periods:
avg=(M1*1+M2*2+M3*3+M4*4+M5*5+M6*6)/21
(M1: 6 months ago, M2: 5 months ago, M3: 4 months ago, ..., M6: previous month).
Each month can have no feedback, one feedback or more.
Therefore I need first aggregate the feedback received per month and average them.
Expected result is below
wt | Row Labels | Average of Feedback | wma |
1 | Jan-22 | 8.00 | |
2 | Feb-22 | 10.00 | |
3 | Apr-22 | 9.00 | |
4 | Aug-22 | 10.00 | |
5 | Sep-22 | 10.00 | |
6 | Oct-22 | 9.00 | 9.48 |
Nov-22 | 10.00 | 9.67 | |
Dec-22 | 3.00 | 7.76 | |
Feb-23 | 10.00 | 8.19 | |
Aug-23 | 7.50 | 7.86 | |
Sep-23 | 8.00 | 7.79 | |
Oct-23 | 9.00 | 8.10 | |
Jan-24 | 2.00 | 6.40 | |
Feb-24 | 8.00 | 6.81 | |
Mar-24 | 10.00 | 7.55 | |
Apr-24 | 9.00 | 8.00 | |
May-24 | 9.00 | 8.38 | |
Jun-24 | 9.67 | 8.90 |
where wma is =SUMPRODUCT(C2:C78,$A$2:$A$7)/SUM($A$2:$A$7)
I have tried this solution, but it does not return expected result
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello @gianma78 , as @ryan_mayu has asked , please help with the following:
.
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

could you pls provide some sample data and expected output?
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello Ryan, sorry for the late reply. In the meantime, requestor changed the specifics for this calc.
What we aim to obtain is the weighted moving average per scores, and the moving should be based on a fix amount of months (or rating received).
Assuming the following example
Date of Delivery | Project | Rating |
06/2023 | P23_001 | 7 |
06/2023 | P23_002 | 5 |
08/2023 | P23_003 | 9 |
09/2023 | P23_004 | 8 |
12/2023 | P23_005 | |
01/2024 | P24_001 | 6 |
01/2024 | P24_002 | 9 |
It is a sample of the table I have, I can calculate the moving average as following DAX
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

what's the expected output basd on the sample data you provided?
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-24-2024 11:44 PM | |||
03-27-2025 07:44 AM | |||
10-22-2024 10:18 AM | |||
06-15-2016 12:27 AM | |||
02-11-2021 01:34 PM |
User | Count |
---|---|
132 | |
105 | |
85 | |
55 | |
46 |