Forum Discussion
Removing numbers from duration in Power BI
Hello all,
I am trying to measure duration of calls in power BI. I managed to convert the date into decimals and decimals into time duration, but the result of time duration displays like this:
I basically need to for this to display as
hh:mm:ss
Using the first value as an example:
Id like to see only the numbers in bold
0.01:45:49.9075200
Thanks in advance!
HI jurodriguez,
I'd like to suggest you add a custom column to extract the different parts from duration values to use in #time function:
#"Added Custom" = Table.AddColumn(#"Renamed Columns", "Custom", each #time(Duration.Hours([Duration]),Duration.Minutes([Duration]),Duration.Seconds([Duration])))Duration functions - PowerQuery M | Microsoft Learn
Regards,
Xiaoxin Sheng
1 Reply
HI jurodriguez,
I'd like to suggest you add a custom column to extract the different parts from duration values to use in #time function:
#"Added Custom" = Table.AddColumn(#"Renamed Columns", "Custom", each #time(Duration.Hours([Duration]),Duration.Minutes([Duration]),Duration.Seconds([Duration])))Duration functions - PowerQuery M | Microsoft Learn
Regards,
Xiaoxin Sheng