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.
I want to convert HH:MM:SS format of time into seconds.
Whenever I change it using format and use SECONDS it only gets the seconds of that time not the whole duration in seconds.
Thanks for answering! Really appreaciate it!
Solved! Go to Solution.
@Anonymous Does this work for you
Column = MINUTE(Table[date time])*60+SECOND(Table[date time])
In case you also have hours in your datetime field please extract the hour and multiple by 3600
You can also try DATEDIFF function and use second as third argument
@Anonymous Have you tried second function
Column = SECOND(table[date time])
Hi Vimal, thanks for answering, however its still showing only seconds of the time that i wanted to convert.
Ex.
00:28:53 - im only getting the 53 seconds whenever i use the dax formala that you've given.
@Anonymous What exactly you need
Suppose if the value is 00:28:53 --> output --?
You can few more example with expected outcome
instead of 53 seconds only, I wanted also to convert the 28min into seconds as well. So in total, I wanted a result of 1733sec.
Is there any easiest way to convert this one aside from manually compute it ?
@Anonymous Does this work for you
Column = MINUTE(Table[date time])*60+SECOND(Table[date time])
In case you also have hours in your datetime field please extract the hour and multiple by 3600
You can also try DATEDIFF function and use second as third argument
Wow! That was fast ! Thanks Vimal, you're great.
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 |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |