Monthly Archives: February 2018

DAX Duration Measure in Days, Hours, Minutes, Seconds

Posted on February 13, 2018 by Tom Huguelet

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, … Continue reading →

Posted in Analysis Services, Business Intelligence, DAX, SQL Server | Leave a comment