Building an order timeline

[andi2333]

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

[lbendlin]

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-...

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/1447...