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

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

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.

Forum Discussion