Business Intelligence in Microsoft® SharePoint® 2010
by Mariano Teixeira Neto Norman P. Warren John Campbell, and Stacia Misner
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 ... |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access