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
AbdulazizSIO
New Member

Dealing with long operation hours

Hi, 

I'm trying to deal with long pump operation hours.  please find the attached What is the right format that will help me to sum or get the average of these hours?

 

  issue.JPG

2 REPLIES 2
AbdulazizSIO
New Member

it will take the first two digits of the hours, and I need 4 digits.

JadhavVarsha_13
Resolver II
Resolver II

You can write a measure for average time:

avgTime = Format(AVERAGE(timeAvg[time]), "HH:MM: SS") 

 

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.