Time and duration have always gotten short shrift when it comes to DAX. Even though there are over 30 DAX functions classified as time intelligence, very few of them actually have anything to do with time in terms of hours, minutes, and seconds. And it wasn't until recently that you could actually aggregate durations but have the result displayed in the HH:mm:ss format. But despite DAX's lack of focus and effort on time and duration, time and duration can actually be just as important to a business and that business' analytics as calendar dates—sometimes even more so.
This chapter is all about demonstrating how to perform proper DAX calculations and analysis with time and duration, filling in some of the holes as it were in the DAX function library for actual time intelligence.
The following recipes will be covered in this...