dax for avg talk duration

[Anonymous]

hi

i have a coulmn showing talk duration 

but i wanted to display the avg of talk duration.

[v-cazheng-msft · Accepted solution]

Hi, @Anonymous 

You can try the following steps.

1 Create a Calculated column

duration = HOUR('Table'[Talk Duration])*3600+MINUTE('Table'[Talk Duration])*60+SECOND('Table'[Talk Duration])

2 Create a Measure

Average_Duration =

VAR avr = AVERAGE ( 'Table'[duration] ) RETURN TIME ( 0, 0, avr )

The result looks like this:

Here is the pbix.

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

@Anonymous 

you can create a meausre

measure=average(table[Talk Duration])

[Anonymous]

hi ryan

i have tried applying ur query but unable to display the value

[ryan_mayu]

@Anonymous 

please change the data type to time and  make sure your raw data is correct.

I did a test, the year month day value maybe affect the result. If so, please remove them and only keep the time value.

.

average seconds

average = AVERAGE('Table'[Talk Duration])*60*60*24