Forum Discussion
Building an order timeline
Hello,
I have multiple input excel files which show orders which are identified as stuck in our supply chain systems. The report is issued every workday.
Now, in PowerBI, I want to measure and show the average duration an order is "stuck" in our systems. I am not sure how to construct this query though, I think the biggest problem is that I would need to calculate the "numbers of days stuck" dynamically from the fact if an order shows up in the report or not.
As an example:
Report 24.04.2024
order 1234
order 5678
Report 25.04.2024
order 5678
This should result in the count that order 1234 was 1 day stuck, while order 5678 would (for now) count as 2 (since it is still open when it's going to be fixed).
I would appreciate any idea how I can model this in PBI.
Thanks
1 Reply
For each given day, summarize all orders stuck on this day, and count the number of days for each of these orders in the past (including the given day).
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to 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.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
