Converting Duration Into numbers and text

[Anonymous]

Hello,

Im trying to convert the "days" column to read days, minutes, and hours. This column for example already has it broken down with the criteria needed. Just need it to show int he following format "684 days, 22 hours, 55mins".    Thanks!

[ppm1]

Please see this article. It explains how to keep your duration as a decimal (in days) and then format it at the end in your measure.

Calculate and Format Durations in DAX – Hoosier BI

Pat