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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
novice1
New Member

Calculate average time from latest date average

I want to calculate the average time from the latest date of the table. My table looks like this.

 

datetime                                 date                   time

01/01/2008 03:23:45              01/01/2008        00:03:56

01/01/2008 04:20:45              01/01/2008        00:02:15

01/01/2008 01:23:45              01/01/2008        00:01:56

01/01/2007 03:23:45              01/01/2007        00:03:56

01/01/2007 03:23:45              01/01/2007        00:03:56

01/01/2007 03:23:45              01/01/2007        00:03:56

 

I want to display as average time for 01/01/2008 by calculating the average time taken from 3 valuses from time column.

 

Avg Time : 00:02:13 (from latest date)

 

any help is appreciated. thanks

0 REPLIES 0

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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