Visual Intelligence: Microsoft Tools and Techniques for Visualizing Data

Appendix B

DAX Function Reference

Data Analysis Epressions (DAX), is the language used by both PowerPivot and the Tabular mode of Analysis Services, and will be of great use during your data analysis. This appendix contains a function reference.

Updated Function Reference

Microsoft maintains an updated function reference at http://msdn.microsoft.com/en-us/library/ee634396.aspx.

Date and Time Functions

Date and time functions, as listed in Table B-1, allow for the manipulation of data stored in datetime formats.

Table B-1: Date and Time Functions

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 the start date. Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.
EOMONTH(<start_date>, <months>)	Returns the date, in datetime format, of the last day of the month, before or after a specified number of months. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.
HOUR(<datetime>)	Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).
MINUTE(<datetime>)	Returns the minute as a number from 0 to 59, given a date and time value.
MONTH(<datetime>)	Returns the month as a number ...