Forum Discussion
Solved
Calculate backlog over past time
Hi there! I have a table containing all orders and specific dates related to that order. In simple words there is a processing date, a production date, a shipping date and a billing date. The ord...
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 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