Monthly Archives: February 2018

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

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