Duration.From

The function returns a duration value based on the input value provided. If the input value is null, the function will also return null. If the input value is already a duration, it will simply be returned as is. The function can convert values of specific types to a duration value: - Text: The function will convert a textual elapsed time in the format of days:hours:minutes:seconds to a duration value. For more information, refer to the Duration.FromText function. - Number: The function will convert a numerical value representing the total number of days (including fractional days) to a duration value. If the input value is of any other type, an error will be returned.

Transform the value of 2.525 into a duration format using Power Query. Apply the MDuration.From function to achieve this conversion. The output will be represented as #duration(2, 12, 36, 0).