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.
Date and time functions, as listed in Table B-1, allow for the manipulation of data stored in datetime formats.
|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 ...|