Report Portal

DAX Duration Measure in Days, Hours, Minutes, Seconds

Credit where credit is due. This is an enhancement of the technique originally posted here by @konstantinos and @smoupre.

A client needed a duration expressed in this format: 2 days, 05:03:52

In other words, Whenever the duration exceeds 86,400 seconds, express that portion in days, then build the remainder in hh:mm:ss format.

Read more...

 

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.