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 ID |
I have attached a sample pbix file and have calculated the difference between the days but not sure how to calculate the average cycle time.
Please assist me.
2 Replies
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
