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,
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 tried like this but its not working
@jaweher899 Thanks for your reply. I am getting below error.
Actually my duration is in text format.
Duration.ToText([Complete]-[Started])
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" )
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 |
---|---|
114 | |
99 | |
81 | |
70 | |
61 |
User | Count |
---|---|
148 | |
116 | |
104 | |
89 | |
65 |