Get the difference between 2 dates and then average it by category

[rnambiar]

I have a table with 3 columns Entity, Start_Date and End_Date as follows:

Entity	Start	End
A	1/1/2024	1/31/2024
A	1/28/2024	2/12/2024
A	5/1/2024	6/5/2024
B	7/31/2024	8/27/2024
B	8/7/2024	10/6/2024
B	9/24/2024	10/31/2024
C	10/22/2024	12/28/2024
C	1/6/2025	4/15/2025
C	3/17/2025	5/18/2025

I am trying to compute the "Average difference" for each entity.  The expected result should be (average difference of start and end for each group)

A = 27

B = 41

C = 76

I tried the following DAX code:

AVERAGEX(

        SUMMARIZE('actrec - PVI','actrec - PVI'[Company],'actrec - PVI'[ctcdte],'actrec - PVI'[sttdte]),

        DATEDIFF('actrec - PVI'[ctcdte],'actrec - PVI'[sttdte],DAY)

    )

This just returns the overall average of the 3 categories. 

Thanks for your help.

[lbendlin · Accepted solution]

[rnambiar]

thank you.  this also worked.

[ThxAlot · Accepted solution]

[rnambiar]

Thank you this worked.

[lbendlin · Accepted solution]