Calculate & show average Time Elapsed?

[speterson]

Hi Team!

Can you please help me with this seeminly simple situation?

I first need to calculate the time elapsed between 2 different dates

and then have it displayed in such a way that will show me the average time elapsed in days

THANK YOU! 

[v-luwang-msft]

HI @speterson ,

Test the below,create a new column,as your picture provided:

Timeelapsed = DATEDIFF('Table'[Date assigned],'Table'[Date Completed],DAY)

Then create a measure:

average = CALCULATE(SUM('Table'[Timeelapsed]),ALL('Table'))/CALCULATE(DISTINCTCOUNT('Table'[Order#]),ALL('Table'))

Output:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[lbendlin · Accepted solution]

Please specify what the time elapsed is between 20-Feb and 21-Feb.  Is it one day or two days?

You can use

Elapsed = AVERAGEX(Orders,Orders[Date Completed]-Orders[Date Assigned])

, for example.