Calculation Of Cycle Time Average

[Anonymous]

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.

PBIX File 

Please assist me.

[Anonymous]

Hi @Sujit_Thakur @amitchandak @Greg_Deckler 

Can any of you please help me here?

[Greg_Deckler]

@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