Business Intelligence in Microsoft® SharePoint® 2010

Appendix B. DAX Function Reference

This appendix lists the functions currently available in DAX.

Date and Time Functions

The basic date and time functions available in PowerPivot mainly operate as converters between text and datetime types. Also, other “time intelligence” functions are specific to PowerPivot and are covered in the subsection Time Intelligence Functions later in this appendix.

Function	Description
DATE(<year>, <month>, <day>)	Returns the specified date in datetime format.
DATEVALUE(date_text)	Converts a date in the form of text to a date in datetime format.
DAY(<date>)	Returns the day of the month, a number from 1 to 31.
EDATE(<start_date>, <months>)	Returns the date that is the indicated number of months before or ...