topic Re: Adding time columns hh:mm:ss in DAX Commands and Tips

Adding time columns hh:mm:ss

Anonymous — Mon, 30 Oct 2023 10:54:09 GMT

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

Re: Adding time columns hh:mm:ss

FreemanZ — Mon, 30 Oct 2023 10:41:02 GMT

try to post some sample data

Re: Adding time columns hh:mm:ss

ppm1 — Mon, 30 Oct 2023 12:31:25 GMT

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