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.
Hi!
New to PBI, I need your help: I have a column of data imported from excel with waiting times. I had it in excel format 37:30:55, but it's lost in PBI - for a previous waiting time of 28:37:39, I get in PBI "01/01/1900 04:37:39", in text format. Changing the format to time, I'm left with 04:37:39, which is the wrong information. I saw the 2016 answer to the one previous post about this subject, but it doesn't quite fit what I need to do.
Appreciate all the help you can give me!
Thanks!!
Iva
Hi @IvaMaia,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share some data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
Hi @IvaMaia,
Please refer to the similar threads below which has been solved.
https://community.powerbi.com/t5/Desktop/Problems-with-hours-greater-than-24-hours/td-p/112680
https://community.powerbi.com/t5/Desktop/PowerQuery-Duration-more-than-24-hours/td-p/267272
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi!
Relatively new to PBI, I have a column of data imported from excel, with waiting times, that were in excel time format 37:30:55.
In PBI, in time format, all waiting times > 24 hours are lost -eg 28:00:00 hours of waiting, changes to 04:00:00.
Does anyone know how to get the equivalent to excel format 37:30:50 in PBI?
Thanks a lot for your help!
Iva
Leave it as text ?
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |