Forum Discussion
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...
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