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.