Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Select the Column > Add Column > Time > Minutes then repeat for Hours.
Does the time period exceed 24 hrs?
just as an example....
on the 1st row the travel value is 6 minutes and the repair time is 10 minutes. Originally 00:06 and 00:10 respectively.
However on the highlighted cell, the repair time is 1 hour. Originally 01:00
Thank you
Hi,
my understanding is that PQ is automatically detecting the column type and setting it to "Date/Time". Given that you are interested in displaying the data in those columns as duration you can simply click on the column and from the ribbon or the context menu change the data type to "Duration".
Select the Column > Add Column > Time > Minutes then repeat for Hours.
Does the time period exceed 24 hrs?
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |