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
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
Community ChampionOk 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 Time
and 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