Calculation Of Cycle Time Average

Anonymous · ‎09-24-2020

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.

Anonymous · ‎09-25-2020

Can any of you please help me here?

Greg_Deckler · ‎09-26-2020

@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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources