Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dax help for Timestamp format

Hi,   Can any one please help me to format below Total Duration Org as below expected format      Expected total duration 694     0 Days 00:01:00 694     7 Days  00:07:08   I have trie...
Need Help
jaweher899's avatar
jaweher899
Impactful Individual
3 years ago

please try

 

Column =
VAR Days = INT( 'Table1'[Total Duration Org] / 86400 )
VAR Hours = INT( ( 'Table1'[Total Duration Org] - ( Days * 86400 ) ) / 3600 )
VAR Minutes = INT( ( 'Table1'[Total Duration Org] - ( Days * 86400 ) - ( Hours * 3600 ) ) / 60 )
VAR Seconds = MOD( 'Table1'[Total Duration Org], 60 )
RETURN
Days & " Days " &
FORMAT( Hours, "00" ) & ":" &
FORMAT( Minutes, "00" ) & ":" &
FORMAT( Seconds, "00" )