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.
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?
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |