Get the average time from timestamps

[Anonymous]

Hello!

I would like to get the average time of these timestamps:

First I have to combine all these timestamps, its a couple if thousands timestamps. I did it in excel and got the result 42777 hours and then I need to divide it with a column named "ID" and then get the average time of 42777 hours right? How do I do that the smartest way in power bi desktop?

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

Create a measure,not a column.

What you want is like below?

Click here （Page 2) to download pbix file if you need!

Wish it is helpful for you!

Best Regards

Lucien

[v-luwang-msft]

Hi @Anonymous ,

Could you pls share your  pbix file? Remember to remove the confidential information.

Best Regards

Lucien 

[Anonymous]

@v-luwang-msft Hello! I sent you a PM

[v-luwang-msft]

Hi @Anonymous ,

You could try the following measure:

Measure = FORMAT(AVERAGE('Table'[Timestamps]),"HH:MM: SS")

Then create two visual ,final you will get like below:

Wish it is helpful for you!

Best Regards

Lucien Wang

[Anonymous]

@v-luwang-msft Thanks you, this worked! I get the average om my timestamps now. But now i'm stuck on another thing regarding this. I got a slider where I have a date hieraki, when I try to use that slider to check between 2 dates the measure wont change. Any idea why? Should I start another thread for this maybe?

[amitchandak]

@Anonymous , refer these blog on how to deal with duration in power bi

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389