Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculation Of Cycle Time Average

I need assistance in calculating Cycle Time Average-   Requirement is like below-   Cycle Time average  Average # of days between submission date  and End date for all unique application I...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Anonymous I did this:

     

    Measure = AVERAGEX(SUMMARIZE('DataSet',[Application Id],"CycleCount",(MIN([End Date]) - MAX('DataSet'[Submission Date])) * 1.),[CycleCount])

     

    Updated PBIX is attached below sig