Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
it will take the first two digits of the hours, and I need 4 digits.
You can write a measure for average time:
avgTime = Format(AVERAGE(timeAvg[time]), "HH:MM: SS")
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |