AVERAGE OF A MEASUREMENT (TIME ELAPSED IN WEEKS)

[Syndicate_Admin]

I need to calculate the average of a measure that calculates the difference in weeks between two dates. The problem is that the start date and end date are in the same column that is, I have more than one record and what I do to calculate the number of weeks elapsed is to take the maximum for that record the minimum for that record and then subtract them, the number of elapsed weeks is calculated perfect, But now I'm trying to calculate the average of that measure and I can't figure it out.

Category	Registration Date
Registration A	Date 1
Registration A	Date 2
Registration A	Date 3

My measurement does the following QTY Weeks = DATEDIFF(min(DateRecord]),max([DateRecord]),WEEK)

What I want to calculate is AVERAGE(QTY Weeks)

Thank you!

[Syndicate_Admin]

Thank you very much Perfect work!

[campelliann]

Thank you :). Could you please accept this as solution. Best regards.
 BTW, you dont actually need the addcolumns, although is more intuitive. You can just do the averagex (Values,expression)

[campelliann · Accepted solution]

Hello, try this measure:

AVERAGEX(ADDCOLUMNS(VALUES(Table1[Regist]),"@datediff",DATEDIFF(CALCULATE(MIN(Table1[Date])),CALCULATE(Max(Table1[Date])),WEEK)),[@datediff])