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.
Kind of surprised this wasn't already out there but here is a converter for a duration in decimal form to something else. You might end up with a decimal duration when doing math on two date/time columns like:
([Date1] - [Date2]) * 1.
Conversion Measure =
VAR __Value = SUM([Decimal Days])
VAR __Days = TRUNC(__Value)
VAR __Hours = TRUNC ( (__Value - __Days) * 24 )
VAR __Minutes = TRUNC ( (__Value - __Days - __Hours / 24) * 24*60 )
VAR __Seconds = TRUNC ( (__Value - __Days - __Hours / 24 - __Minutes/24/60) * 24*60*60 )
RETURN
__Days&":"&__Hours&":"&__Minutes&":"&__Seconds
eyJrIjoiZGRlZmJlMTctNjA1Mi00NWM2LWE1MjUtY2ZmYTIwZTkyMzVkIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9
Thank you. This is great.