Forum Discussion
6 Week Rolling Average
I need to calculate a six week rolling average with duplicates of product ID removed before calculating the average. I have looked at lots of other people's posts about similar situations which is ho...
lbendlin
Super User
Super UserPlease provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
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/1447523
Hi lbendlin , hopefully this sample data helps. I appreciate the help.
| Product ID | Sold | Customer | Date |
| 2010 | 331 | A | 7/10/2023 |
| 1776 | 471 | B | 7/11/2023 |
| 2908 | 603 | A | 7/12/2023 |
| 2474 | 620 | C | 7/13/2023 |
| 2892 | 341 | C | 7/13/2023 |
| 1824 | 302 | B | 7/17/2023 |
| 2597 | 581 | B | 7/18/2023 |
| 2483 | 335 | A | 7/18/2023 |
| 2682 | 240 | A | 7/20/2023 |
| 1203 | 284 | C | 7/21/2023 |
- lbendlin
Not really. If you want a 6 week rolling average you need to provide at least 7 but better 12 or more weeks of sample data.