Forum Discussion
Rolling calaculation over multiple weeks
Hello,
I hope to find some advice on how to solve the following problem:
(1) I have a database which records orders. Each order has a status which can move over time ("draft", "placed", "shipped", "delivered"). There is no date log on the status change, hence I cannot tell when an order moved from placed to shipped, etc.
However, every week, a snapshot from the database is taken into a csv file and stored on a sharepoint.
(2) I get a separate report which shows orders being stuck in our supply chain due to whatever reason. Those are usually a subset of the orders in (1) with status "placed".
--> I now would like to calculate the % of orders stuck vs open orders (status "placed") over the past weeks and show the numbers in a line chart.
Is this achievable?
Thanks!!
1 Reply
andi2333 Better Rolling Average - Microsoft Fabric Community
Otherwise, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
