O'Reilly logo

Business Intelligence in Microsoft® SharePoint® 2010 by Mariano Teixeira Neto Norman P. Warren John Campbell, and Stacia Misner

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

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

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