Forum Discussion
Historical Data Reports
Hi, Would someone be able to kindly help me with this problem I have a data table which contains the created date and completion date of a unique work order I need to look back over time ...
Hi Zoe
Thank you for taking the time to resond
Apologies - yes you are right it should be 3 orders not completed for August
The cycle time is calcuated by totalling the time to complete and dividing by the total number of orders
Many Thanks
So my work so far
I have created 2 new columns for the created date and actual end date which extracts the Month
Completed Month = Format([Actual End].[Month],"MMM")
I have exported this data into Excel to try and work out the formula for the table visual
I have 2 tables 1. Total Orders Created 2. Total Orders Completed
| Month | Total Orders Created |
| August | 1291 |
| September | 1784 |
| Grand Total | 3075 |
| Month | Total Orders Completed |
| August | 479 |
| September | 1921 |
| Outstanding | |
| Grand Total | 2400 |
The output table would be
| August Work Basket | 812 |
| September Work Basket | 675 |
August Formula = 1291-479 = 812
Sept Formula = (1784+812)-1921 = 675
How do I replicate this in PowerBI?
Or have I gone about this totally the wrong way?