Forum Discussion
Calculate backlog over past time
Hi patrickmlsk ,
I have updated your sample pbix file, please check whether that is what you want.
1. Create a date table
2. Create some measures to get the related backlogs
Best Regards
Hi patrickmlsk ,
As checked your description, the whole flow is as follow: Order open--> Process--> Production-->Shipping --> Billing. And the related date will be filled after each stage be completed. Did you want to get the number of orders in each stage as below? Whether my understanding is correct or not?
order backlog=count(all orders)
processing backlog=count(order with only order date)
production backlog=count(order with order date and processing date)
shipping backlog=count(order with order date ,processing date and production date )
billing backlog=count(order with order date ,processing date ,production date and shipping date) Best Regards
Hi Anonymous
thank you for your response. Your assumptions are correct. You can also see what I mean in the pbix that I included in my latest response.
Calculating these numbers for today is easy, but visualising them historically in a line graph is what despairs me.. Maybe you have an idea?
Hi patrickmlsk ,
I have updated your sample pbix file, please check whether that is what you want.
1. Create a date table
2. Create some measures to get the related backlogs
Best Regards