Chapter 8Date & Time Functions 1/2: Basic Functions

For the purpose of clarity, the Date & Time functions in DAX have been divided into two chapters. This is the first of those two chapters and deals with the more basic date and time functions. The next chapter is devoted to a group of Date & Time functions that are often referred to as time intelligence functions. The basic functions are often simpler and more forgiving. The time intelligence functions usually require that you have put some thought into how your dates are stored in the PowerPivot model. The emphasis in this chapter is on parsing, manipulating, and returning dates. The basic functions generally return dates and times. The time intelligence functions generally return measures ...

Get Practical PowerPivot & DAX Formulas for Excel 2010 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.