Forum Discussion
Running totals per week
Greetings,
I solved the issue myself. It was caused by duplicates in my table.
Thanks for thinking along regardless!
Super UserDo you want the running total to reset at the beginning of each week?
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi Ibendlin,
Thank you for your reply. I don't want the running total to reset at the beginning of each week. I just want the cumulative version of "kg per week" times "marketprice for said crop in that week" for the whole season.
I will try a few things and if that won't work, I will try to make some sample data.