Forum Discussion

KG1's avatar
KG1
Resolver I
6 years ago

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 ...
Need Help
dax's avatar
dax
Community Support
6 years ago

Hi KG1,

If possible, could you please explain the logic to me? Count the number of orders not completed before month end in Augest should be 3

In addition, I want to know how you calculate the Average Cycle time? could you please explain to me?

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • KG1's avatar
    KG1
    Resolver I
    6 years ago

    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

     

     

    • KG1's avatar
      KG1
      Resolver I
      6 years ago

      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

       

      MonthTotal Orders Created
      August1291
      September1784
      Grand Total3075

       

      MonthTotal Orders Completed
      August479
      September1921
      Outstanding
      Grand Total2400

       

      The output table would be

      August Work Basket812
      September Work Basket675

       

      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?

    • dax's avatar
      dax
      Community Support
      6 years ago

      Hi KG1

      I am still can't get the average result like you, so if possible, could you please write the expression for me. You could refer to my sample.

      In addition , if possible, could you please inform me more detailed information for your second problem? Then I will help you more correctly.

      Please do mask sensitive data before uploading.

      Thanks for your understanding and support.
      Best Regards,
      Zoe Zhi

      If this post helps, then please consider Accept it as the solution to help the other members find i