O'Reilly logo

Visual Intelligence: Microsoft Tools and Techniques for Visualizing Data by Adam Jorgensen, Joe Salvatore, Mark Stacey

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

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

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

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