Calculate Average time

[SRK_23]

Hi, how to calculate average time by "PlaformEntityName" ? 

I've got 3 calculated column which are:

Duration_Max = CALCULATE( MAX(dm_pageview_company[Date]) , 
                          FILTER( dm_pageview_company , 
                                  dm_pageview_company[SessionId] =  EARLIER(dm_pageview_company[SessionId]) 
                                ) 
                            )

Duration_Min = CALCULATE( MIN(dm_pageview_company[Date]) , 
                          FILTER( dm_pageview_company , 
                                  dm_pageview_company[SessionId] =  EARLIER(dm_pageview_company[SessionId]) 
                                ) 
                            )
                        

Duration_Calc = [Duration_Max] - [Duration_Min]

I've got a tab like that and would like to get the average session time by 'PlaformEntityName' which are a Text field with client's name:

[URL=https://www.casimages.com/i/181213015203273498.png.html][IMG]https://nsa39.casimages.com/img/2018/12...]

[AlB · Accepted solution]

Hi @SRK_23

I'm uploading back your file here with the measure i posted earlier included.