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,
Is there a way to convert a text column to show as seconds. The column holds text values in the format of HH:MM.
E.g 64:56 should show as 233760 seconds. There will be values greater than 24 hours
Thanks
Yasir
Solved! Go to Solution.
Column 2 =
LEFT ( 'Table'[Column1], LEN ( 'Table'[Column1] ) - 3 ) * 3600
+ RIGHT ( 'Table'[Column1], 2 ) * 60
Column 2 =
LEFT ( 'Table'[Column1], LEN ( 'Table'[Column1] ) - 3 ) * 3600
+ RIGHT ( 'Table'[Column1], 2 ) * 60
@yaman123 , a new column
in Second = left([Column],2) *60*60 + right([Column],2 )*60
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |