Forum Discussion
Convert negative decimal numbers to time (Long Time)
I'm trying to convert negative decimal numbers to a time displayed as hh:nn:ss (Long Time), however, it's giving me an error: Instead of converting the "Verschil" column, I also tried to calcu...
Rather than creating a DAX calculated column, consider keeping your column as a decimal, creating your measure and do the formatting at the end (assuming the result is >0, or you will still get an error). Please see this article.
Calculate and Format Durations in DAX – Hoosier BI
Pat