Transforming milliseconds into duration

Some source systems have millisecond precision. However, measuring things in milliseconds tends to result in large numbers that are more easily consumed in a duration format such as HH:mm:ss:000 (hours, minutes, seconds, and milliseconds). This DAX recipe demonstrates how to transform durations stored in milliseconds into a more readable duration format of HH:mm:ss:000.

Getting ready

To prepare for this recipe, do the following:

1. Open Power BI Desktop and use an Enter Data query to create a table called R08_Table with the following data:

Milliseconds	ID	Group
25920	1	1
44999	2	1
12550	3	2
2456	4	2
175	5	3
1244999	6	3

2. Ensure...