Duration.ToRecord

The function will provide a data set that includes the duration value from which the record is generated, named duration.duration.

Transform the duration of 2 days, 5 hours, 55 minutes, and 20 seconds into a breakdown where each part is separated including days, hours, minutes, and seconds if applicable. This can be achieved by using the Power Query MDuration.ToRecord function on the duration value of 2 days, 5 hours, 55 minutes, and 20 seconds. The output of this transformation will display each part of the duration separately as shown below: Days = 2 Hours = 5 Minutes = 55 Seconds = 20