O'Reilly logo

Practical PowerPivot & Dax Formulas For Excel® 2010 by Art Tennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required