Forum Discussion
Converting Duration Into numbers and text
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!
1 Reply
ppm1Solution Sage
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