Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
On my other tables i have the data formatted as time so I can convert to total seconds and then divide by the seconds in the working day (In order to get Utilisastion)
I would ideally like to add the drilling time and production time together for each part. Then divide by seconds in the day.
I may be going about this the wrong way so I am open to suggestions and new methods.
Thanks,
Hi @Anonymous ,
You can create column or measure using DAX below. Then convert them to Time data type.
Column:
convert Drilling Time = FORMAT(CONCATENATE("00:",Table1[Drilling Time]),"hh:mm:ss")
convert Production Time = var d=IF(Table1[Production Time]=BLANK(),"00:00:00",IF(LEN(Table1[Production Time])=1,CONCATENATE("00:00:0",Table1[Production Time]),CONCATENATE("00:00:",Table1[Production Time])))
return FORMAT(d,"hh:mm:ss")
Measure:
convert Drilling Time measure = FORMAT(CONCATENATE("00:",MAX(Table1[Drilling Time])),"hh:mm:ss")
convert Production Time measure = var d=IF(MAX(Table1[Production Time])=BLANK(),"00:00:00",IF(LEN(MAX(Table1[Production Time]))=1,CONCATENATE("00:00:0",MAX(Table1[Production Time])),CONCATENATE("00:00:",MAX(Table1[Production Time]))))
return FORMAT(d,"hh:mm:ss")
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thats a huge Help amy and nearly 100% there.
I have just found out that some of the data in the production time data is greater that 60 seconds so I am unable to convert to time.
Any suggestions @v-xicai ?
some Drilling time is also greater than 60 minutes
Thanks for your help thus far
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |