Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Get the average time from timestamps

Hello!

 

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

288088_0-1615479466178.png

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?

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

Create a measure,not a column.

What you want is like below?

v-luwang-msft_0-1616032065439.pngv-luwang-msft_1-1616032077535.png

 

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

 

Wish it is helpful for you!

 

Best Regards

Lucien

View solution in original post

6 REPLIES 6
v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

Create a measure,not a column.

What you want is like below?

v-luwang-msft_0-1616032065439.pngv-luwang-msft_1-1616032077535.png

 

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

 

Wish it is helpful for you!

 

Best Regards

Lucien

v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

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

 

Best Regards

Lucien 

Anonymous
Not applicable

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

v-luwang-msft
Community Support
Community Support

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:
12.png
Wish it is helpful for you!
Best Regards
Lucien Wang
Anonymous
Not applicable

@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?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.