Forum Discussion

SRK_23's avatar
SRK_23
Helper I
7 years ago
Solved

Calculate Average time

Hi, how to calculate average time by "PlaformEntityName" ?    I've got 3 calculated column which are:     Duration_Max = CALCULATE( MAX(dm_pageview_company[Date]) , F...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi SRK_23

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

  • AlB's avatar
    AlB
    7 years ago

    Hi SRK_23

    Yeah, it's correct. That's the same. I said earlier that the measure shows the result in minutes

    2,37 minutes is 2 mins and 22 seconds, 2:22

AlB's avatar
AlB
Community Champion
7 years ago

Hi SRK_23

If you wanted the result in the format Mins:secs instead, you could do something like:

 

AverageSessionTime_Mins_Secs = 
VAR __AverageSessionTime= 
AVERAGEX (
    VALUES ( dm_pageview_company[Duration_Calc] );
    dm_pageview_company[Duration_Calc]
)
RETURN
MINUTE(__AverageSessionTime) & ":" & SECOND(__AverageSessionTime)
SRK_23's avatar
SRK_23
Helper I
7 years ago

Thank you !