Adding time columns hh:mm:ss

[Anonymous]

Good Morning.

I am fairly new to PowerBI and seem to be doing something quite simple or i thinkit is as its simple in excel.

I have 3 columns AHT, Hold and Wrap - they are stored in Time format HH:MM:SS i want to add these 3 columns together everytime i do it i get a column full or ERROR.

00:12:23	00:00:00	00:01:00	result - 00:13:23
01:23:45	09:00:02	00:21:00	result -10:44:47
00:00:00	00:23:00	00:53:03	result - 00:76:03 or 01:16:03
04:34:01	00:12:22	00:23:23	result - 04:69:46 or 05:09:46

[ppm1]

In the query editor, you can convert the 3 time columns to duration and then add a custom column that simply adds those columns together.

Note that when you load the data, it will be converted to decimal (in days), but you can easily display your desired format (hh:mm:ss, etc.) with format strings or using the FORMAT function in DAX.

Calculate and Format Durations in DAX – Hoosier BI

Pat

[FreemanZ]

try to post some sample data