Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |