Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |