How can I get the average cycle (days) when calculating two date columns?

[antoniosantos]

Hello,

How can I get the average cycle in days, given the table dates below?

Start Date	End Date
06/12/2023	07/10/2023
05/01/2023
01/01/2023	05/30/2023
02/02/2023

I guess that if there is no End Date, then there should be no calculation.

Appreciate your help in this begginer question.

[Ritaf1983 · Accepted solution]

Hi @antoniosantos 
Try measure :

avg cicle = CALCULATE(AVERAGEX('Table',DATEDIFF('Table'[Start Date],'Table'[End Date],DAY)),'Table'[End Date]<>blank())

Link to the sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly