Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
How can i convert the following from a Text Calculated Column to a Integer so i can sum the total time.
HH:MM:SS =
RIGHT ( "0" & INT ( vw_fct_irs_time_taken[Time Taken in seconds] / 3600 ), 2 )
& ":"
& RIGHT (
"0"
& INT ( ( vw_fct_irs_time_taken[Time Taken in seconds] - INT (vw_fct_irs_time_taken[Time Taken in seconds] / 3600) * 3600) / 60 ),
2
)
& ":"
& RIGHT ( "0" & MOD (vw_fct_irs_time_taken[Time Taken in seconds], 60 ), 2 )
@Anonymous , refer these methods
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389