Forum Discussion
HOW CAN I GET THE FINAL TIME OF THE CALLS?
Ok lets rather do it in Power Query
Add a custom column to total the seconds
Here is the Code :
Time.Hour([Hour]) * 3600
+
Time.Minute([Hour]) * 60
+
[Second]Then
Add another Custom Column to convert it to Timeand here is the code :
#time(0,0,0) + #duration(0,0,0,[Hour converted to seconds])
Finally Change the type of the column to Time
Third Option would be this DAX
Let me know
Community ChampionHey Anonymous
Firts add a column to covert the time to all seconds
Then add a new column to convert all seconds to Time
And here are the 2 DAX codes:
VAR _Hour =
INT ( MOD ( 'Convert'[Hour To Sec], 86400 ) / 3600 )
VAR _Minute =
DIVIDE (
INT ( MOD ( MOD ( 'Convert'[Hour To Sec], 86400 ), 3600 ) ) - 'Convert'[Second],
60
)
RETURN
_Hour & ":" & _Minute & ":" & 'Convert'[Second]
Thanks aj1973 ! I could get the column with the Time. Nevertheless, the format is in Text and I need it in Time. When I try to change the format the result is: #ERROR in all rows. Why I can't convert it to a Time format?
Regards,
Bibi
Jara
- aj1973
Ok lets rather do it in Power Query
Add a custom column to total the seconds
Here is the Code :
Time.Hour([Hour]) * 3600
+
Time.Minute([Hour]) * 60
+
[Second]Then
Add another Custom Column to convert it to Timeand here is the code :
#time(0,0,0) + #duration(0,0,0,[Hour converted to seconds])
Finally Change the type of the column to Time
Third Option would be this DAX
Let me know
Yes! aj1973 I finally made it!
I solved it through Power Query. Really, thank you so much for your help. I can't be more grateful.
Kind regards,
Bibi