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
I'm new to PowerBi, and I'm trying to convert a time value (12:50:04) to a integer (125004). For this, I'm doing the following:
a) Converting the time to text
b) Replacing the : for (nothing)
c) Converting the text to integer.
The problem is that in step a), the conversion ignores the seconds, leaving a value like 12:50 and not 12:50:04 as expected.
In one of my tables it works.. but in the others not, not sure why. How can I solve this?
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
That is interesting! I received the same results, but what I did was change the time to date time first. Then you could delete first characters.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @Anonymous ,
That is interesting! I received the same results, but what I did was change the time to date time first. Then you could delete first characters.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
This was great, except when I went to convert the date time to text, it changed the time from 9:00AM to 8:59AM. It removed a second from all of the times?
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 |
---|---|
96 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |